[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
> 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  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 .
If you upgrade to 0.22-fixes or trunk r22750 or higher, all should work
More information about the mythtv-users