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

[Christopher X. Candreva]

On Sun, 26 Feb 2012, Josh Mastronarde wrote:

> On Sun, Feb 26, 2012 at 1:31 PM, Jean-Yves Avenard <jyavenard at gmail.com> wrote:
> >
> > 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 |

> ...

> It took many hours (I want to say 6-8; overnight, basically) to do the
> same update to 1216 when I went from 0.21->0.24 on a 3.0GHz Core 2
> Duo.  I had played with mysql settings, ext4 barriers, debug logging,
> etc, before just taking the one time hit and letting it run; it did
> finish eventually, and everything works fine now.

There is definately a bug in the update from 1215 to 1216 then, under Mysql 
5.5.  The line above where it says "waiting for schema metadata lock" shows 
a deadlock condition. There is only one request running and it is waiting 
for a lock.   I'm guesing the 6-8 hours is some lock timing out.

I found a frontend still running Fedora 14 with mysql 5.1, loaded my 
database there, and the 1215 to 1216 part of the update took seconds.

I found a mention of this in a web search, it was a post from a while ago 
which is what made me go looking for a frontend I had still running F14.

I can understand if it is old enough no one wants to bother with it though.



==========================================================
Chris Candreva  -- chris at westnet.com -- (914) 948-3162
WestNet Internet Services of Westchester
http://www.westnet.com/