[mythtv-users] error when fixing database forced by mythtv upgrade

[Petr Stehlik]

Hi,

I have just tried upgrading from 0.21-fixes to SVN trunk:

2009-09-27 11:15:57.976 Current MythTV Schema Version (DBSchemaVer): 1214
2009-09-27 11:15:57.977 MythTV database schema is old. Waiting to see if DB is being upgraded.
2009-09-27 11:15:58.977 New DB connection, total: 2
2009-09-27 11:15:58.978 Connected to database 'mythconverg' at host: localhost
2009-09-27 11:15:58.984 Current MythTV Schema Version (DBSchemaVer): 1214
2009-09-27 11:15:59.989 Current MythTV Schema Version (DBSchemaVer): 1214
2009-09-27 11:16:00.995 Current MythTV Schema Version (DBSchemaVer): 1214
2009-09-27 11:16:02.000 Current MythTV Schema Version (DBSchemaVer): 1214
2009-09-27 11:16:03.005 Current MythTV Schema Version (DBSchemaVer): 1214
2009-09-27 11:16:03.005 Timed out waiting.
2009-09-27 11:16:03.023 Backing up database with script: '/home/joy/myth/22/share/mythtv/mythconverg_backup.pl'
2009-09-27 11:16:10.015 Database Backup complete.
2009-09-27 11:16:10.019 Backed up database to file: '/myth/tv/mythconverg-1214-20090927111603.sql.gz'
2009-09-27 11:16:50.200 Newest MythTV Schema Version : 1244
2009-09-27 11:16:50.207 Upgrading to MythTV schema version 1215
2009-09-27 11:16:50.207 New DB connection, total: 3
2009-09-27 11:16:50.208 Connected to database 'mythconverg' at host: localhost
2009-09-27 11:16:52.472 Database corruption detected. Unable to proceed with database upgrade. (Table: oldrecorded, Warnings: 91)
2009-09-27 11:16:52.472 Your database must be fixed before you can upgrade beyond 0.21-fixes. Please seehttp://www.mythtv.org/wiki/index.php/Fixing_Corrupt_Database_Encoding for information on fixing your database.
2009-09-27 11:16:52.472 Database Schema upgrade FAILED, unlocking.
2009-09-27 11:16:52.472 Couldn't upgrade database to new schema.

Followed the wiki at http://www.mythtv.org/wiki/Fixing_Corrupt_Database_Encoding:

the sed script didn't change anything in my my.cnf so I just dropped the
database, created a new empty one, tried to restore the data and got
this error:

/home/joy/myth/22/share/mythtv/mythconverg_restore.pl --filename mythconverg-to_uncorrupt.sql --directory /var/tmp
ERROR 1062 (23000) at line 1700: Duplicate entry 'Samuel Ivaška (Slovenská republika' for key 2

ERROR: Cannot write to mysql, stopped at /usr/local/myth/share/mythtv/mythconverg_restore.pl line 1523, <BACKUP> line 1701.

Petr