<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=ISO-8859-1">
</head>
<body text="#003300" bgcolor="#ffffff">
Hi,<br>
<br>
I'm trying to upgrade an old release of Mythtv (schema 1214)
following a re-install to Ubuntu 10.04, I was running Ubuntu 8.04
unpatched mostly.<br>
<br>
The automatic DB upgrade started by mythbackend is failing:<br>
<br>
<code>2010-06-22 18:45:00.101 MythTV database schema is old. Waiting to
see if DB is being upgraded.<br>
2010-06-22 18:45:01.101 New DB connection, total: 2<br>
2010-06-22 18:45:01.103 Connected to database 'mythconverg' at host:
mytv<br>
2010-06-22 18:45:01.109 Current MythTV Schema Version (DBSchemaVer):
1215<br>
...<br>
2010-06-22 18:45:05.129 Timed out waiting.<br>
2010-06-22 18:45:05.148 Backing up database with script:
'/usr/share/mythtv/mythconverg_backup.pl'<br>
2010-06-22 18:45:23.036 Database Backup complete.<br>
2010-06-22 18:45:23.041 Backed up database to file:
'/export/video/mythconverg-1215-20100622184505.sql.gz'<br>
2010-06-22 18:45:23.136 Console is non-interactive, can't prompt user...<br>
2010-06-22 18:45:23.136 Upgrading.<br>
2010-06-22 18:45:23.151 Newest MythTV Schema Version : 1254<br>
2010-06-22 18:45:23.398 <b>Database corruption detected. Unable to
proceed with database upgrade</b>. (Table: oldrecorded, Warnings: 2)<br>
2010-06-22 18:45:23.398 Your database must be fixed before you can
upgrade beyond 0.21-fixes. Please see <a class="moz-txt-link-freetext" href="http://www.mythtv.org">http://www.mythtv.org</a><b>/wiki/Fixing_Corrupt_Database_Encoding</b>
for information on fixing your database.<br>
2010-06-22 18:45:23.399 Database Schema upgrade FAILED, unlocking.<br>
2010-06-22 18:45:23.399 Couldn't upgrade database to new schema<br>
2010-06-22 18:45:24.190 mythbackend version:
branches/release-0-23-fixes [24158] <a class="moz-txt-link-abbreviated" href="http://www.mythtv.org">www.mythtv.org</a><br>
</code><br>
Following the instructions in the Wiki doesn't resolve the issue.<br>
The output of the "status;" command returns a different result than
contained in the wiki:<br>
<br>
<font face="Courier New, Courier, monospace" color="#000000">mysql
-umythtv -pmythtv mythconverg -e 'status;'<br>
--------------<br>
mysql Ver 14.14 Distrib 5.1.41, for debian-linux-gnu (i486) using
readline 6.1<br>
<br>
Connection id: 159<br>
SSL: Not in use<br>
Current pager: stdout<br>
Using outfile: ''<br>
Using delimiter: ;<br>
Server version: 5.1.41-3ubuntu12.3 (Ubuntu)<br>
Protocol version: 10<br>
Connection: Localhost via UNIX socket<br>
Client characterset: latin1<br>
Server characterset: latin1<br>
UNIX socket: /var/run/mysqld/mysqld.sock<br>
Uptime: 53 min 54 sec<br>
<br>
Threads: 1 Questions: 4521 Slow queries: 0 Opens: 1391 Flush
tables: 1 Open tables: 203 Queries per second avg: 1.397<br>
--------------</font><br>
<br>
This may be what is causing mythtv-backend to fail the upgrade.<br>
I suspect that the use of mysql v. 5.1.41 instead of the "old" 5.0
explains this difference of output.<br>
mysql/my.cnf doesn't define any character sets by default.<br>
<br>
<font face="Courier New, Courier, monospace" color="#000000">%mytv[48]
grep character /etc/mysql/my.cnf<br>
%mytv[49] <br>
</font><br>
When I followed the Wiki instructions to de-corrupt my DB, there was
just a small change:<br>
<br>
<font face="Courier New, Courier, monospace" color="#000000">2010-06-22
17:47:48.748 Database corruption detected. Unable to proceed with
database upgrade. (Table: oldrecorded, Warnings:<b> 2</b>)<br>
2010-06-22 18:45:23.398 Database corruption detected. Unable to proceed
with database upgrade. (Table: oldrecorded, Warnings: <b>1</b>)<br>
</font><br>
<br>
I can restore the old DB anytime I want as I have kept the old OS,
software and DB on a separate disk which I keep using in the meanwhile.<br>
<br>
Any ideas, hints, solutions are more than welcome.<br>
<br>
Alain<br>
</body>
</html>