[mythtv-users] Upgrad failing from schema 1214 to 1265
Christopher X. Candreva
chris at westnet.com
Mon Feb 27 04:59:34 UTC 2012
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/
More information about the mythtv-users
mailing list