Opened 2 years ago

Closed 2 years ago

Last modified 20 months ago

#13079 closed Bug Report - General (fixed)

Change to MYSQL_OPT_READ_TIMEOUT causes errors when running mythfilldatabase

Reported by: gregorio.gervasio@… Owned by: Peter Bennett
Priority: minor Milestone: 29.0
Component: MythTV - General Version: Unspecified
Severity: medium Keywords:
Cc: Ticket locked: no

Description

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.)

Change History (6)

comment:1 Changed 2 years ago by Peter Bennett

Owner: set to Peter Bennett
Status: newassigned

comment:2 Changed 2 years ago by 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.

comment:3 Changed 2 years ago by Peter Bennett <pbennett@…>

Resolution: fixed
Status: assignedclosed

In f7fe2d5f01ad3c5166d1aca66e25f1d99c6e7cde/mythtv:

Fixes #13079 - Increase MySQL Read Timeout.

comment:4 Changed 2 years ago by Peter Bennett <pbennett@…>

In 696806310a5ff3e972da2e660392c8fc9570bb96/mythtv:

Fixes #13079 - Increase MySQL Read Timeout.

(cherry picked from commit f7fe2d5f01ad3c5166d1aca66e25f1d99c6e7cde)

comment:5 Changed 2 years ago by Stuart Auchterlonie

Milestone: needs_triage29.0

comment:6 Changed 20 months ago by Peter Bennett

Owner: changed from Peter Bennett to Peter Bennett
Note: See TracTickets for help on using tickets.