[mythtv-users] Upgrad failing from schema 1214 to 1265

Jean-Yves Avenard jyavenard at gmail.com
Sun Feb 26 21:31:13 UTC 2012


Hi

On Monday, 27 February 2012, Christopher X. Candreva <chris at westnet.com>
wrote:
>
> I am attempting to upgraed a combined FE/BE from an older verions (0.23 I
> believe) to latest from atrmps. This also involves an upgrade from older
> fedora to fedora 16, which runs Mysql 5.5
>
> The schema updates to 1215, then hangs while updating to 1216. From
looking
> at the mysqlprocesslist, I see a line:
>
>  4  | mythtv | localhost | mythconverg | Query   | 23   | Waiting for
schema
> metadata lock | ALTER DATABASE mythconverg DEFAULT CHARACTER SET latin1 |
>
> Is this an sql problem I can work around, or a bug in the current atrpms
> packages ?

It took over 5 minutes to upgrade that particular change set on a 2.8GHz C2D

Do not interrupt it, let it run to completion. If you have interrupted it,
restore the backup that was created prior the first upgrade and redo it all.

By interrupted it, your DB may now be in a corrupted state.

That was the case for me when I upgraded a backend from 0.21 to 0.24
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.mythtv.org/pipermail/mythtv-users/attachments/20120227/13d3b54c/attachment.html 


More information about the mythtv-users mailing list