[mythtv-users] DB charset pre-conversion test failed! Your database seems to be partially corrupted.

Michael T. Dean mtdean at thirdcontact.com
Sun Nov 15 05:24:10 UTC 2009


On 11/09/2009 02:39 PM, Brian J. Murrell wrote:
> On Mon, 2009-11-09 at 14:19 -0500, Michael T. Dean wrote: 
>   
>> Upload a gzip'ed or bzip2'ed copy of your pre-upgrade (0.21-fixes/1214 
>> DB schema version) database to http://filebin.ca/ and e-mail me a link 
>> (directly--not on list--and using the same subject so I don't lose it) 
>> and I'll tell you exactly what's broken.
>>     
> Much appreciated!  I'd be interested in how you are finding what is
> broken so easily.  Manual inspection or are you using a tool?

Manual inspection backed up by lots of experience with the mythconverg 
schema.

>   I'd
> really like to be self-service on this in the future.
>
> You can get it from
>   
...
> That's the backup that was made during this operation:
>
> 2009-11-08 17:35:30.454 mythbackend version: branches/release-0-22-fixes [22750] www.mythtv.org
> 2009-11-08 17:35:30.473 Using runtime prefix = /usr
> 2009-11-08 17:35:30.484 Using configuration directory = /root/.mythtv
> 2009-11-08 17:35:30.511 Empty LocalHostName.
> 2009-11-08 17:35:30.527 Using localhost value of pvr
> 2009-11-08 17:35:30.645 New DB connection, total: 1
> 2009-11-08 17:35:30.692 Connected to database 'mythconverg' at host: localhost
> 2009-11-08 17:35:30.707 Closing DB connection named 'DBManager0'
> 2009-11-08 17:35:30.721 Connected to database 'mythconverg' at host: localhost
> 2009-11-08 17:35:30.750 Current MythTV Schema Version (DBSchemaVer): 1215
> 2009-11-08 17:35:30.762 MythTV database schema is old. Waiting to see if DB is being upgraded.
> 2009-11-08 17:35:31.774 New DB connection, total: 2
> 2009-11-08 17:35:31.789 Connected to database 'mythconverg' at host: localhost
> 2009-11-08 17:35:31.815 Current MythTV Schema Version (DBSchemaVer): 1215
> 2009-11-08 17:35:32.833 Current MythTV Schema Version (DBSchemaVer): 1215
> 2009-11-08 17:35:33.853 Current MythTV Schema Version (DBSchemaVer): 1215
> 2009-11-08 17:35:34.873 Current MythTV Schema Version (DBSchemaVer): 1215
> 2009-11-08 17:35:35.893 Current MythTV Schema Version (DBSchemaVer): 1215
> 2009-11-08 17:35:35.913 Timed out waiting.
> 2009-11-08 17:35:36.067 Backing up database with script: '/usr/share/mythtv/mythconverg_backup.pl'
> 2009-11-08 17:36:27.841 Database Backup complete.
> 2009-11-08 17:36:27.938 Backed up database to file: '/video/mythtv/mythconverg-1215-20091108173536.sql.gz'
> 2009-11-08 17:36:28.263 Console is non-interactive, can't prompt user...
> 2009-11-08 17:36:28.327 Upgrading.
> 2009-11-08 17:36:28.359 Newest MythTV Schema Version : 1244
> QSqlQuery::exec: database not open
> 2009-11-08 17:37:17.232 DB Error (Index creation failed.):
> Query was:
>
> Driver error was [1/-1]:
> Driver not loaded
> Database error was:
> Driver not loaded
>
> 2009-11-08 17:37:17.292 DB charset pre-conversion test 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.
> 2009-11-08 17:37:17.352 Database Schema upgrade FAILED, unlocking.
> 2009-11-08 17:37:17.407 Couldn't upgrade database to new schema

I finally got around to looking at it and  ...  the database backup you 
gave me upgraded just fine.  And, unfortunately, you're running Qt 4.5, 
so the pre-upgrade charset tests don't work so we get a failure at the 
end of the test (when creating a test index).

My best guess is that you were affected by the issue fixed in [22750].  
If you upgrade to 0.22-fixes or trunk r22750 or higher, all should work 
fine.

Mike


More information about the mythtv-users mailing list