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

[Per Jessen]

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?



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