[mythtv-users] failing upgrade from 0.21-fixes to 0.23-fixes using mysql 5.1 / Ubuntu 10.4

[Alain Brossard]

Hi,

    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.

    The automatic DB upgrade started by mythbackend is failing:

|2010-06-22 18:45:00.101 MythTV database schema is old. Waiting to see 
if DB is being upgraded.
2010-06-22 18:45:01.101 New DB connection, total: 2
2010-06-22 18:45:01.103 Connected to database 'mythconverg' at host: mytv
2010-06-22 18:45:01.109 Current MythTV Schema Version (DBSchemaVer): 1215
...
2010-06-22 18:45:05.129 Timed out waiting.
2010-06-22 18:45:05.148 Backing up database with script: 
'/usr/share/mythtv/mythconverg_backup.pl'
2010-06-22 18:45:23.036 Database Backup complete.
2010-06-22 18:45:23.041 Backed up database to file: 
'/export/video/mythconverg-1215-20100622184505.sql.gz'
2010-06-22 18:45:23.136 Console is non-interactive, can't prompt user...
2010-06-22 18:45:23.136 Upgrading.
2010-06-22 18:45:23.151 Newest MythTV Schema Version : 1254
2010-06-22 18:45:23.398 *Database corruption detected. Unable to proceed 
with database upgrade*. (Table: oldrecorded, Warnings: 2)
2010-06-22 18:45:23.398 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 on fixing your database.
2010-06-22 18:45:23.399 Database Schema upgrade FAILED, unlocking.
2010-06-22 18:45:23.399 Couldn't upgrade database to new schema
2010-06-22 18:45:24.190 mythbackend version: branches/release-0-23-fixes 
[24158] www.mythtv.org
|
     Following the instructions in the Wiki doesn't resolve the issue.
The output of the "status;" command returns a different result than 
contained in the wiki:

mysql -umythtv -pmythtv mythconverg -e 'status;'
--------------
mysql  Ver 14.14 Distrib 5.1.41, for debian-linux-gnu (i486) using 
readline 6.1

Connection id:        159
SSL:            Not in use
Current pager:        stdout
Using outfile:        ''
Using delimiter:    ;
Server version:        5.1.41-3ubuntu12.3 (Ubuntu)
Protocol version:    10
Connection:        Localhost via UNIX socket
Client characterset:    latin1
Server characterset:    latin1
UNIX socket:        /var/run/mysqld/mysqld.sock
Uptime:            53 min 54 sec

Threads: 1  Questions: 4521  Slow queries: 0  Opens: 1391  Flush tables: 
1  Open tables: 203  Queries per second avg: 1.397
--------------

    This may be what is causing mythtv-backend to fail the upgrade.
I suspect that the use of mysql v. 5.1.41 instead of the "old" 5.0 
explains this difference of output.
   mysql/my.cnf doesn't define any character sets by default.

%mytv[48] grep character /etc/mysql/my.cnf
%mytv[49]

   When I followed the Wiki instructions to de-corrupt my DB, there was 
just a small change:

2010-06-22 17:47:48.748 Database corruption detected. Unable to proceed 
with database upgrade. (Table: oldrecorded, Warnings:* 2*)
2010-06-22 18:45:23.398 Database corruption detected. Unable to proceed 
with database upgrade. (Table: oldrecorded, Warnings: *1*)


   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.

   Any ideas, hints, solutions are more than welcome.

Alain
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mythtv.org/pipermail/mythtv-users/attachments/20100622/e3d6444e/attachment.htm>