Opened 4 months ago

Last modified 2 months ago

#13577 new Bug Report - General

fixes/31 mythfrontend interworking with mythbackend on Xubuntu 20.04 Daily build

Reported by: Mike Bibbings Owned by:
Priority: minor Milestone: needs_triage
Component: MythTV - General Version: v31-fixes
Severity: medium Keywords:
Cc: Ticket locked: no

Description

fixes/31 mythfrontend built from source on Xubuntu 18.04 LTS to mythbackend built from debs on Xubuntu 20.04 Daily build.

The mythfrontend tries to upgrade various schema (mytharchive, mythmusic) and silently fails. mythfrontend actually works in to the remote mythbackend e.g. LiveTV. Xubuntu 18.04 LTS uses mysql 5.7.29 components.

Attached is frontend log which shows sql errors when attempting to upgrade schema. mythbackend is running mysql 8.

mike@mike-GL62-7QF:~$ mythfrontend --version
Please attach all output as a file in bug reports.
MythTV Version : v31-Pre-1874-g35cb9ed0c5
MythTV Branch : fixes/31
Network Protocol : 91
Library API : 31.20200101-1
QT Version : 5.9.5
Options compiled in:
 linux profile use_hidesyms using_alsa using_oss using_pulse using_pulseoutput using_backend using_bindings_perl using_bindings_python using_bindings_php using_dvb using_firewire using_frontend using_hdhomerun using_vbox using_ceton using_hdpvr using_ivtv using_joystick_menu using_libcec using_libcrypto using_libdns_sd using_libfftw3 using_libxml2 using_lirc using_mheg using_opengl using_egl using_qtwebkit using_qtscript using_qtdbus using_taglib using_v4l2 using_v4l2prime using_x11 using_libbluray_external using_xrandr using_profiletype using_systemd_notify using_systemd_journal using_drm using_bindings_perl using_bindings_python using_bindings_php using_freetype2 using_mythtranscode using_opengl using_egl using_drm using_vaapi using_nvdec using_vdpau using_ffmpeg_threads using_mheg using_libass using_libxml2

Mike

Attachments (2)

mythfrontend.20200207160948.3691.log (69.8 KB) - added by Mike Bibbings 4 months ago.
mythfrontend.20200207163703.3462.log (61.3 KB) - added by Mike Bibbings 4 months ago.

Download all attachments as: .zip

Change History (5)

Changed 4 months ago by Mike Bibbings

comment:1 Changed 4 months ago by Mike Bibbings

Done some more testing on Xubuntu 20.04 Daily build. Turns out mythfrontend schema upgrade fails with local mythfrontend.

I installed mythmusic plugin and ran mythfrontend, and schema upgrade silently fails.

Frontend log attached

mike@xubuntu2004-focal:~$ mythfrontend --version
Please attach all output as a file in bug reports.
MythTV Version : v31-Pre-1874-g35cb9ed0c5-dirty
MythTV Branch : fixes/31
Network Protocol : 91
Library API : 31.20200101-1
QT Version : 5.12.5
Options compiled in:
 linux profile use_hidesyms using_alsa using_oss using_pulse using_pulseoutput using_backend using_bindings_perl using_bindings_python using_bindings_php using_dvb using_firewire using_frontend using_hdhomerun using_vbox using_ceton using_hdpvr using_ivtv using_joystick_menu using_libcec using_libcrypto using_libdns_sd using_libfftw3 using_libxml2 using_lirc using_mheg using_opengl using_egl using_qtwebkit using_qtscript using_qtdbus using_taglib using_v4l2 using_v4l2prime using_x11 using_libbluray_external using_xrandr using_profiletype using_systemd_notify using_systemd_journal using_drm using_bindings_perl using_bindings_python using_bindings_php using_freetype2 using_mythtranscode using_opengl using_egl using_drm using_vaapi using_nvdec using_vdpau using_ffmpeg_threads using_mheg using_libass using_libxml2 using_libmp3lame

Changed 4 months ago by Mike Bibbings

comment:2 Changed 4 months ago by Gary Buhrmaster

fwiw, mysql 8 changes the default character set from latin1 to utf8mb4, and I would not be surprised if "DEFAULT CHARACTER SET default" no longer means what it used to mean.

comment:3 Changed 2 months ago by Mike Bibbings

A user on mythtv forum has come up with a possible solution (a patch) see https://forum.mythtv.org/viewtopic.php?p=17769#p17769

This changes the sql in dbcheck to be compatible with mysql 8.

I have not tested this and would like someone with mysql expertise to comment, particularly with respect to possible impact of such changes on earlier versions of mysql and mariadb.

Mike

Note: See TracTickets for help on using tickets.