Mailing List Archive

[MythTV/mythtv] e55471: DB: Reconnect if MySQL error code 4031 is received
Branch: refs/heads/master
Home: https://github.com/MythTV/mythtv
Commit: e55471f0776911a82ded3e008abbd3158f2e40b5
https://github.com/MythTV/mythtv/commit/e55471f0776911a82ded3e008abbd3158f2e40b5
Author: Bill Meek <billmeek@mythtv.org>
Date: 2021-05-25 (Tue, 25 May 2021)

Changed paths:
M mythtv/libs/libmythbase/mythdbcon.cpp
M mythtv/libs/libmythbase/mythdbcon.h

Log Message:
-----------
DB: Reconnect if MySQL error code 4031 is received

A new error code was introduced in MySQL client v8.0.24 that
mythdbcon.cpp didn't handle. Users would loose the ability
to make any recordings.

Reported on the -users list and Forum for Ubuntu 20.04 users
after a recent updat to mysql* v8.0.25 and MythTV v31.0 or
master. Two MariaDB users also reported.

Tests with wait_timeout set to 300 (seconds).

18.04 (which doesn't have the problem):
Scheduler scheduler.cpp:2310 (HandleReschedule) - Reschedule requested for PLACE PrepareToRecord
Scheduler mythdbcon.cpp:947 (lostConnectionCheck) - SQL Native Error Code: 2006
Scheduler mythdbcon.cpp:260 (Reconnect) - MySQL reconnected successfully

20.04:
Scheduler scheduler.cpp:2309 (HandleReschedule) - Reschedule requested for MATCH 0 0 0 - MythUtilCommand
Scheduler mythdbcon.cpp:879 (prepare) - SQL Native Error Code: 4031
Scheduler mythdbcon.cpp:260 (Reconnect) - MySQL reconnected successfully

No testing on MariaDB has been yet.

Refs #359


_______________________________________________
mythtv-commits mailing list
mythtv-commits@mythtv.org
http://lists.mythtv.org/mailman/listinfo/mythtv-commits