[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