[mythtv-users] Myth Database Upgrade failed preventing 0.22 from starting on gentoo.

[John Drescher]

On Sat, Dec 5, 2009 at 2:36 PM, Michael T. Dean <mtdean at thirdcontact.com> wrote:
> On 12/05/2009 02:02 PM, John Drescher wrote:
>>>
>>> Did you try upgrading from the original backup?
>>
>> No. Yesterday, I had
>>
>> Server characterset:    utf8
>> Db     characterset:    latin1
>> Client characterset:    utf8
>> Conn.  characterset:    utf8
>>
>> with 0.21-fixes. I followed the guide
>>
>> http://www.mythtv.org/wiki/Fixing_Corrupt_Database_Encoding
>>
>> to get my database to
>>
>> Server characterset:    latin1
>> Db     characterset:    latin1
>> Client characterset:    latin1
>> Conn.  characterset:    latin1
>>
>> under 0.21 fixes still. I used 0.21 in this condition for the evening
>> and then tried the 0.22 upgrade today.
>>
>
> Which meant that when you started using 0.21-fixes with the proper MySQL
> configuration, it was writing valid data into a database full of corrupt
> data.  That is what caused your partial corruption.
>
>>> If you've tried both the original pre-upgrade 0.21-fixes backup and the
>>> "uncorrupted" backup you show your using above, then you have partial
>>> corruption, and you'll need to do:
>>>  http://www.gossamer-threads.com/lists/mythtv/users/406111#406111 .
>>
>> Thanks I will look into that.
>
> Or go back to the upgrade you made before changing the database server
> configuration and you can probably make that work.
>

Thank You. It looks like that worked. I still had the
mythconverg-to_uncorrupt.sql  from last evening.

jmd0 mythtv # ~john/scripts/mythconverg_restore.pl --filename
temp/mythconverg-to_uncorrupt.sql

Successfully restored backup.
jmd0 mythtv # mythbackend
2009-12-05 14:40:01.320 mythbackend version:
branches/release-0-22-fixes [exported] www.mythtv.org
2009-12-05 14:40:01.320 Using runtime prefix = /usr
2009-12-05 14:40:01.320 Using configuration directory = /root/.mythtv
2009-12-05 14:40:01.320 Using localhost value of jmd0
2009-12-05 14:40:01.325 New DB connection, total: 1
2009-12-05 14:40:01.328 Connected to database 'mythconverg' at host:
jmd0
2009-12-05 14:40:01.328 Closing DB connection named 'DBManager0'
2009-12-05 14:40:01.329 Connected to database 'mythconverg' at host:
jmd0
2009-12-05 14:40:01.333 Current MythTV Schema Version (DBSchemaVer):
1214
2009-12-05 14:40:01.333 MythTV database schema is old. Waiting to see
if DB is being upgraded.
2009-12-05 14:40:02.333 New DB connection, total: 2
2009-12-05 14:40:02.333 Connected to database 'mythconverg' at host:
jmd0
2009-12-05 14:40:02.336 Current MythTV Schema Version (DBSchemaVer):
1214
2009-12-05 14:40:03.338 Current MythTV Schema Version (DBSchemaVer):
1214
2009-12-05 14:40:04.340 Current MythTV Schema Version (DBSchemaVer):
1214
2009-12-05 14:40:05.342 Current MythTV Schema Version (DBSchemaVer):
1214
2009-12-05 14:40:06.344 Current MythTV Schema Version (DBSchemaVer):
1214
2009-12-05 14:40:06.344 Timed out waiting.
2009-12-05 14:40:06.351 SG(Default) Error: FindNextDirMostFree:
'/mnt/mythtv/jmd0_vg_0/videos' does not exist!
2009-12-05 14:40:06.352 SG(Default) Error: FindNextDirMostFree:
'/mnt/mythtv/jmd1_vg1_1/videos' does not exist!
2009-12-05 14:40:06.353 SG(Default) Error: FindNextDirMostFree:
'/mnt/mythtv/jmd1_vg_1/videos' does not exist!
2009-12-05 14:40:06.353 SG(Default) Error: FindNextDirMostFree:
'/mnt/mythtv/jmd1_vg1_2/videos' does not exist!
2009-12-05 14:40:06.354 SG(Default) Error: FindNextDirMostFree:
'/mnt/mythtv/jmd1_vg2_1/videos' does not exist!
2009-12-05 14:40:06.354 SG(Default) Error: FindNextDirMostFree:
'/mnt/mythtv/jmd1_vg3_1/videos' does not exist!
2009-12-05 14:40:06.355 SG(Default) Error: FindNextDirMostFree:
'/mnt/mythtv/jmd1_vg3_2/videos' does not exist!
2009-12-05 14:40:06.357 Backing up database with script:
'/usr/share/mythtv/mythconverg_backup.pl'
2009-12-05 14:40:16.036 Database Backup complete.
2009-12-05 14:40:16.038 Backed up database to file:
'/mnt/mythtv/jmd0_vg_2t0_1/videos/mythconverg-1214-20091205144006.sql.gz'

Warning: MythTV wants to upgrade your database,
for the TV schema, from 1214 to 1244.

Database Host: jmd0
Database Name: mythconverg

If your system becomes unstable, a database backup is located in
/mnt/mythtv/jmd0_vg_2t0_1/videos/mythconverg-1214-20091205144006.sql.gz


Shall I upgrade this database? [yes]
2009-12-05 14:40:17.656 Newest MythTV Schema Version : 1244
2009-12-05 14:40:17.659 Upgrading to MythTV schema version 1215
2009-12-05 14:40:17.659 New DB connection, total: 3
2009-12-05 14:40:17.659 Connected to database 'mythconverg' at host: jmd0
2009-12-05 14:40:18.671 Upgrading to MythTV schema version 1216
2009-12-05 14:40:21.518 New DB connection, total: 4
2009-12-05 14:40:21.518 Connected to database 'mythconverg' at host: jmd0
2009-12-05 14:40:21.519 Upgrading to MythTV schema version 1217
2009-12-05 14:40:35.633 Upgrading to MythTV schema version 1218
2009-12-05 14:40:35.634 Upgrading to MythTV schema version 1219
2009-12-05 14:40:35.689 Upgrading to MythTV schema version 1220
2009-12-05 14:40:35.700 Upgrading to MythTV schema version 1221
2009-12-05 14:40:35.702 Upgrading to MythTV schema version 1222
2009-12-05 14:40:35.703 Upgrading to MythTV schema version 1223
2009-12-05 14:40:35.704 Upgrading to MythTV schema version 1224
2009-12-05 14:40:35.739 Upgrading to MythTV schema version 1225
2009-12-05 14:40:40.541 Upgrading to MythTV schema version 1226
2009-12-05 14:40:53.277 Upgrading to MythTV schema version 1227
2009-12-05 14:40:54.350 Upgrading to MythTV schema version 1228
2009-12-05 14:40:54.352 Upgrading to MythTV schema version 1229
2009-12-05 14:40:55.892 Upgrading to MythTV schema version 1230
2009-12-05 14:40:55.902 Upgrading to MythTV schema version 1231
2009-12-05 14:40:57.237 Upgrading to MythTV schema version 1232
2009-12-05 14:40:57.249 Upgrading to MythTV schema version 1233
2009-12-05 14:40:57.276 Upgrading to MythTV schema version 1234
2009-12-05 14:40:57.285 Upgrading to MythTV schema version 1235
2009-12-05 14:40:57.294 Upgrading to MythTV schema version 1236
2009-12-05 14:40:57.295 Upgrading to MythTV schema version 1237
2009-12-05 14:40:57.296 Upgrading to MythTV schema version 1238
2009-12-05 14:40:57.306 Upgrading to MythTV schema version 1239
2009-12-05 14:40:57.329 Upgrading to MythTV schema version 1240
2009-12-05 14:40:57.337 Upgrading to MythTV schema version 1241
2009-12-05 14:40:57.351 Upgrading to MythTV schema version 1242
2009-12-05 14:40:57.352 Upgrading to MythTV schema version 1243
2009-12-05 14:40:57.354 Upgrading to MythTV schema version 1244
2009-12-05 14:40:57.356 Database Schema upgrade complete, unlocking.
2009-12-05 14:40:57.358 MythBackend: Starting up as the master server.
2009-12-05 14:40:59.051 New DB scheduler connection

John