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

Brian J. Murrell brian at interlinx.bc.ca
Mon Nov 9 02:41:33 UTC 2009


So, trying to upgrade to 0.22 (r22750) on Ubuntu Karmic using the
Mythbuntu PPA packages, from Mythbuntu's 0.21-fixes (20080304) and am
getting the following on trying to start the backend:

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

So of course, I've looked at
http://www.mythtv.org/wiki/Fixing_Corrupt_Database_Encoding and even
tried the procedure where I backup the database contents and then
applying sed 's/SET NAMES utf8/SET NAMES latin1/' and droping and
recreating mythconverg and thn restoring that file.  Same thing.

What's strange is the mysql configuration I have and had prior to this
upgrade doesn't even mention character sets:

grep character-set /etc/mysql/my.cnf 

And the status test on the database before the upgrade looks fine too:

$ mysql -umythtv -p mythconverg -e 'status;'
Enter password: 
--------------
mysql  Ver 14.12 Distrib 5.0.51a, for debian-linux-gnu (i486) using readline 5.2

Connection id:		49
Current database:	mythconverg
Current user:		mythtv at localhost
SSL:			Not in use
Current pager:		stdout
Using outfile:		''
Using delimiter:	;
Server version:		5.0.51a-3ubuntu5.4 (Ubuntu)
Protocol version:	10
Connection:		Localhost via UNIX socket
Server characterset:	latin1
Db     characterset:	latin1
Client characterset:	latin1
Conn.  characterset:	latin1
UNIX socket:		/var/run/mysqld/mysqld.sock
Uptime:			4 hours 8 sec

Threads: 11  Questions: 43668  Slow queries: 5  Opens: 197  Flush tables: 1  Open tables: 64  Queries per second avg: 3.031
--------------

Which leads me to believe that I should not even be having this problem
in the first place, yes?

What now?

b.

-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 197 bytes
Desc: This is a digitally signed message part
URL: <http://mythtv.org/pipermail/mythtv-users/attachments/20091108/a5af9af5/attachment.pgp>


More information about the mythtv-users mailing list