[mythtv-users] Schema upgrade from 0.21->0.24_fixes hangs

[Michael T. Dean]

On 05/31/2011 07:31 PM, Josh Mastronarde wrote:
> Sorry about the last message; I tried to cut the size down to the
> allowed limit, but pasted (very) wrong.  Trying again:
>
> Well, I'm back to thinking there's a Myth related issue -- I tracked
> the mysql performance problem to being ext4 related; added "barrier=0"
> to the mount options and the test case runs as fast as I'd expect now.
> However, the Myth schema upgrade, either through mythtv-setup or
> mythbackend, still hangs on the first step (1215->1216; it wants to go
> to 1264).  I ran "mythbackend -v all", and the logs are attached
> below.  There's a lot of activity, including database activity in the
> first minute, then nothing after the "Upgrading to MythTV schema
> version 1216" line; I let it sit for 6 hours last night and no further
> log updates appeared.
>
> Any ideas where to look?

Best guess is that your MySQL server or file system is misconfigured or 
your MySQL user permissions are incorrect such that you can't create 
temporary tables.  This can happen if you have a bad temp directory 
specified for MySQL or if your temp directory file permissions are wrong 
or if you haven't granted necessary permissions (ALL) to the MySQL user 
MythTV uses.

Mike