Mailing List Archive: MythTV: Users

mythbackend hangs at: Upgrading to MythTV schema version 1304

Index | Next | Previous | View Threaded

spikeygg.mythbox at gmail

Jul 4, 2012, 7:46 PM

Post #1 of 4 (336 views)
Permalink

mythbackend hangs at: Upgrading to MythTV schema version 1304

I just upgraded to git head (was running from a compile in April), compiled
and I'm trying to get mythbackend started. It gets to the upgrade step
moving the DB to schema version 1304 and seems to hang there. I see the
hard drive light flickering and mysql appears to be going to town but the
log is just sitting there. Is this upgrade very involved or is something
wrong with my DB? Any suggestions on proceeding?

Thanks,
-Greg

spikeygg.mythbox at gmail

Jul 4, 2012, 8:10 PM

Post #2 of 4 (301 views)
Permalink

Re: mythbackend hangs at: Upgrading to MythTV schema version 1304 [In reply to]

On Wed, Jul 4, 2012 at 8:46 PM, Greg Grotsky <spikeygg.mythbox [at] gmail>wrote:

> I just upgraded to git head (was running from a compile in April),
> compiled and I'm trying to get mythbackend started. It gets to the upgrade
> step moving the DB to schema version 1304 and seems to hang there. I see
> the hard drive light flickering and mysql appears to be going to town but
> the log is just sitting there. Is this upgrade very involved or is
> something wrong with my DB? Any suggestions on proceeding?
>

Never mind on this one. It took about a half hour, while it was running I
did some googling and found that it was UTC time zone commit. I'm guessing
it took so long because it updated all the date/time stamps in the DB to
UTC time instead of my specific timezone.

mtdean at thirdcontact

Jul 5, 2012, 10:38 AM

Post #3 of 4 (293 views)
Permalink

Re: mythbackend hangs at: Upgrading to MythTV schema version 1304 [In reply to]

On 07/04/2012 11:10 PM, Greg Grotsky wrote:
> On Wed, Jul 4, 2012 at 8:46 PM, Greg Grotsky wrote:
>
>> I just upgraded to git head (was running from a compile in April),
>> compiled and I'm trying to get mythbackend started. It gets to the upgrade
>> step moving the DB to schema version 1304 and seems to hang there. I see
>> the hard drive light flickering and mysql appears to be going to town but
>> the log is just sitting there. Is this upgrade very involved or is
>> something wrong with my DB? Any suggestions on proceeding?
>>
>
> Never mind on this one. It took about a half hour, while it was running I
> did some googling and found that it was UTC time zone commit. I'm guessing
> it took so long because it updated all the date/time stamps in the DB to
> UTC time instead of my specific timezone.

And note that if you stopped the upgrade while it was in progress and
then re-started and let it finish, you probably corrupted your DB data.
If so, restore the pre-upgrade backup and then let it complete without
interruption.

Mike
_______________________________________________
mythtv-users mailing list
mythtv-users [at] mythtv
http://www.mythtv.org/mailman/listinfo/mythtv-users

gary.buhrmaster at gmail

Jul 5, 2012, 11:19 AM

Post #4 of 4 (292 views)
Permalink

Re: mythbackend hangs at: Upgrading to MythTV schema version 1304 [In reply to]

On Thu, Jul 5, 2012 at 5:38 PM, Michael T. Dean <mtdean [at] thirdcontact> wrote:
....
> And note that if you stopped the upgrade while it was in progress and then
> re-started and let it finish, you probably corrupted your DB data. If so,
> restore the pre-upgrade backup and then let it complete without
> interruption.

While it will not help those with myisam db's, I wonder if a feature
patch adding start transaction;commit (and backout the failure cases)
in the performActualUpdate routine would be accepted (for those with
acid compliant engines). It would increase some resource usage,
but could help deal with some failure modes.
_______________________________________________
mythtv-users mailing list
mythtv-users [at] mythtv
http://www.mythtv.org/mailman/listinfo/mythtv-users

Index | Next | Previous | View Threaded

Interested in having your list archived? Contact Gossamer Threads