Change to MYSQL_OPT_READ_TIMEOUT causes errors when running mythfilldatabase

[gregorio.gervasio@…]

In 119d733df13e88d8ff636730a97d1468bfde1719, there was a change to reduce MYSQL_OPT_READ_TIMEOUT to 30 seconds. This seems to cause errors when running mythfilldatabase:

2017-07-19 10:16:54.763165 I  Updating programs.
2017-07-19 10:17:24.865920 E  Driver error was [2/2013]:
QMYSQL3: Unable to execute statement
Database error was:
Lost connection to MySQL server during query
DB Error (Inserting into program table):
Query was:
INSERT IGNORE INTO program   ( chanid,        starttime,   endtime,         title,               subtitle,      description, showtype,        category, 
[...]

There are more errors after reconnection since the temporary tables are gone:

2017-07-19 10:17:24.866790 I  MySQL reconnected successfully: DataDirectCon
2017-07-19 10:17:24.867534 E  Driver error was [2/1146]:
QMYSQL3: Unable to prepare statement
Database error was:
Table 'mythconverg.dd_v_program' doesn't exist
DB Error (Inserting into programrating table):
Query was:
INSERT IGNORE INTO program   ( chanid,        starttime,   endtime,         title,               subtitle,      description, showtype,        category,     
[...]

If I change the timeout to 300, the errors go away. (From logs, it appears this step typically takes around 80 seconds for this particular videosource.)

[Peter Bennett]

I changed it to reduce the amount of time the frontend hangs if the backend database is shut down. I will increase it again.

[Peter Bennett <pbennett@…>]

In f7fe2d5f01ad3c5166d1aca66e25f1d99c6e7cde/mythtv:

Fixes #13079 - Increase MySQL Read Timeout.

[Peter Bennett <pbennett@…>]

In 696806310a5ff3e972da2e660392c8fc9570bb96/mythtv:

Fixes #13079 - Increase MySQL Read Timeout.

(cherry picked from commit f7fe2d5f01ad3c5166d1aca66e25f1d99c6e7cde)