[mythtv-users] Database upgrade fails - lost connection to MySQL ?

[Per Jessen]

Per Jessen wrote:

> My migration is progressing albeit slowly.  I have now hit this issue
> twice -
> 
> 2019-12-18 17:19:55.724116 E  DB Error (Performing database upgrade):
> Query was: UPDATE recordedseek SET starttime =
> CONVERT_TZ(starttime, 'SYSTEM', 'Etc/UTC') ORDER BY starttime
> Error was: Driver error was [2/2013]:
> QMYSQL: Unable to execute query
> Database error was:
> Lost connection to MySQL server during query
> 
> 2019-12-18 17:19:55.724147 E  Database schema upgrade failed.
> 2019-12-18 17:19:55.767735 I  MySQL reconnected successfully
> 2019-12-18 17:19:55.819067 E  Couldn't upgrade database to new schema.
> 
> The update statement is actually continuing,
> 
> I have just had my third attempt fall over - recordedseek has 54mill
> rows, that update _will_ take a while.  Is there a time out I can
> fiddle with?

It looks like it is the default 300 second timeout that kicks in.  

I patched libmythbase to use MYSQL_OPT_READ_TIMEOUT=999 instead and now
the update process stopped at almost exactly 999 seconds. 

I guess I'm stuck with rebuilding from source to get a sufficient
timeout value? 


-- 
Per Jessen, Zürich (7.2°C)
http://www.dns24.ch/ - your free DNS host, made in Switzerland.