[mythtv-users] Database upgrade fails - lost connection to MySQL ?
Per Jessen
per at computer.org
Wed Dec 18 20:13:24 UTC 2019
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.
More information about the mythtv-users
mailing list