Bug 794838 – media-tv/mythtv current version has a issue with mysql/mariadb disconnection

• Product: Gentoo Linux
• Status: RESOLVED FIXED

[Description zachron 2021-06-07 21:50:18 UTC]

Created attachment 714372 [details]
new mythtv ebuild

I am seeing with current version of mythtv, the issues reported here: https://forum.mythtv.org/viewtopic.php?f=36&t=4453#p21895

tl;dr mythtv keeps disconnecting from mysql/mariadb after ~8 hours and stops recording things, and the only fix is to restart the backend, this is caused by a new error code in mysql/mariadb that was introduced recently that mythtv was not setup to handle

they have fixed the issue in these commits:
https://github.com/MythTV/mythtv/commit/1510439288cb874e51aacd14e248bf14c32269b5
https://github.com/MythTV/mythtv/commit/df29c72b4d1d5aa6728bf1ad4264439a4d121855

and i know in the attached mythtv thread, someone else from here in the gentoo community has reported the same issue, but i did not see anything listed in the bug tracker.

i went and updated the most recent ebuild in my own overlay, to just the newest commit on the fixes/31 branch, and have attached it here.

It built successfully, and should resolve the issue described in the attached thread, as it includes the commits referenced.

this is my first ticket here, if i have done something incorrect, i apologize.

[Comment 1 Larry the Git Cow 2021-06-10 19:05:16 UTC]

The bug has been referenced in the following commit(s):

https://gitweb.gentoo.org/repo/gentoo.git/commit/?id=64b11df61f88d1e784cfce730c9035a24faf2814

commit 64b11df61f88d1e784cfce730c9035a24faf2814
Author:     Wilson Michaels <[e-mail]>
AuthorDate: 2021-06-08 18:39:28 +0000
Commit:     Sam James <[e-mail]>
CommitDate: 2021-06-10 19:05:02 +0000

    media-tv/mythtv: snapshot 20210606 bump, add Python 3.9 target
    
    Bug: https://bugs.gentoo.org/794838
    Package-Manager: Portage-3.0.18, Repoman-3.0.2
    Signed-off-by: Wilson Michaels <[e-mail]>
    Closes: https://github.com/gentoo/gentoo/pull/21165
    Signed-off-by: Sam James <[e-mail]>

 media-tv/mythtv/Manifest                     |   1 +
 media-tv/mythtv/mythtv-31.0_p20210606.ebuild | 435 +++++++++++++++++++++++++++
 2 files changed, 436 insertions(+)

[Comment 2 Larry the Git Cow 2021-08-10 16:22:19 UTC]

The bug has been closed via the following commit(s):

https://gitweb.gentoo.org/repo/gentoo.git/commit/?id=3eec991b890fdf8c7b89bbe61c235335bd93f04f

commit 3eec991b890fdf8c7b89bbe61c235335bd93f04f
Author:     Wilson Michaels <[e-mail]>
AuthorDate: 2021-08-04 15:00:51 +0000
Commit:     Joonas Niilola <[e-mail]>
CommitDate: 2021-08-10 16:22:12 +0000

    media-tv/mythtv: bump snapshot 20210731
    
    Closes: https://bugs.gentoo.org/794838
    
    Package-Manager: Portage-3.0.20, Repoman-3.0.2
    Signed-off-by: Wilson Michaels <[e-mail]>
    Signed-off-by: Joonas Niilola <[e-mail]>

 media-tv/mythtv/Manifest                     |   1 +
 media-tv/mythtv/mythtv-31.0_p20210731.ebuild | 435 +++++++++++++++++++++++++++
 2 files changed, 436 insertions(+)