Help, Mysql (MariaDB?) not starting after upgrading Xubuntu to 20.04

Have a MythTV related problem? Ask for help from other MythTV users here.

Moderator: Forum Moderators

User avatar
bill6502
Developer
Posts: 2325
Joined: Fri Feb 07, 2014 5:28 pm
United States of America

Re: Help, Mysql (MariaDB?) not starting after upgrading Xubuntu to 20.04

Post by bill6502 »

Thanks for the update. I <think> you mean upgrade to 20.04 as I haven't seen MySQL 8.0
before that. apt show mysql-server-8.0 on the 19.10 host will tell.
wmorrison
Senior
Posts: 165
Joined: Sat Dec 01, 2018 12:05 am
United States of America

Re: Help, Mysql (MariaDB?) not starting after upgrading Xubuntu to 20.04

Post by wmorrison »

Yes, MySQL 8.0 can be installed in *buntu 19.10. I did it. Seemed to "hang" for about 5 minutes at 86 percent, but eventually finished.

Without explicitly installing MySQL 8 first, upgrade to 20.04 still wants to replace mysql with mariadb and uninstall mythtv.

I got everything working on 19.10 + MySQL 8 and then upgraded to 20.04. Still had mythtv on hold, don't know if that mattered.

After the upgrade, mythbackend is running, and I can see it has upcoming recordings by accessing it at localhost:6544, but neither mythwelcome nor mythfrontend will run. When run in the console, the last line is "Handling segmentation fault." The last line in mythfrontend.log is "Starting HouseKeeper."

I'm going to leave it as-is for the night, as it is currently recording. Hopefully I can figure out how to get mythfrontend running tomorrow.

Code: Select all

Jun  4 01:37:46 tvtime mythfrontend.real: mythfrontend[4077]: I thread_unknown signalhandling.cpp:191 (SetHandlerPrivate) Setup Interrupt handler
Jun  4 01:37:47 tvtime mythfrontend.real: mythfrontend[4077]: I thread_unknown signalhandling.cpp:191 (SetHandlerPrivate) Setup Terminated handler
Jun  4 01:37:47 tvtime mythfrontend.real: mythfrontend[4077]: I thread_unknown signalhandling.cpp:191 (SetHandlerPrivate) Setup Segmentation fault handler
Jun  4 01:37:47 tvtime mythfrontend.real: mythfrontend[4077]: I thread_unknown signalhandling.cpp:191 (SetHandlerPrivate) Setup Aborted handler
Jun  4 01:37:47 tvtime mythfrontend.real: mythfrontend[4077]: I thread_unknown signalhandling.cpp:191 (SetHandlerPrivate) Setup Bus error handler
Jun  4 01:37:47 tvtime mythfrontend.real: mythfrontend[4077]: I thread_unknown signalhandling.cpp:191 (SetHandlerPrivate) Setup Floating point exception handler
Jun  4 01:37:47 tvtime mythfrontend.real: mythfrontend[4077]: I thread_unknown signalhandling.cpp:191 (SetHandlerPrivate) Setup Illegal instruction handler
Jun  4 01:37:47 tvtime mythfrontend.real: mythfrontend[4077]: I thread_unknown signalhandling.cpp:191 (SetHandlerPrivate) Setup Real-time signal 0 handler
Jun  4 01:37:47 tvtime mythfrontend.real: mythfrontend[4077]: I thread_unknown signalhandling.cpp:191 (SetHandlerPrivate) Setup User defined signal 1 handler
Jun  4 01:37:47 tvtime mythfrontend.real: mythfrontend[4077]: I thread_unknown signalhandling.cpp:191 (SetHandlerPrivate) Setup User defined signal 2 handler
Jun  4 01:37:47 tvtime mythfrontend.real: mythfrontend[4077]: I thread_unknown signalhandling.cpp:191 (SetHandlerPrivate) Setup Hangup handler
Jun  4 01:37:47 tvtime mythfrontend.real: mythfrontend[4077]: C thread_unknown mythcommandlineparser.cpp:2605 (ConfigureLogging) mythfrontend version: fixes [v31.0+fixes.202004112000.2921af5~ubuntu19.04.1] www.mythtv.org
Jun  4 01:37:47 tvtime mythfrontend.real: mythfrontend[4077]: C thread_unknown mythcommandlineparser.cpp:2607 (ConfigureLogging) Qt version: compile: 5.12.2, runtime: 5.12.8
Jun  4 01:37:47 tvtime mythfrontend.real: mythfrontend[4077]: I thread_unknown mythcommandlineparser.cpp:2609 (ConfigureLogging) Ubuntu 20.04 LTS (x86_64)
Jun  4 01:37:47 tvtime mythfrontend.real: mythfrontend[4077]: N thread_unknown mythcommandlineparser.cpp:2611 (ConfigureLogging) Enabled verbose msgs:  general
Jun  4 01:37:47 tvtime mythfrontend.real: mythfrontend[4077]: N thread_unknown logging.cpp:725 (logStart) Setting Log Level to LOG_INFO
Jun  4 01:37:47 tvtime mythfrontend.real: mythfrontend[4077]: N thread_unknown mythdirs.cpp:203 (InitializeMythDirs) Using runtime prefix = /usr
Jun  4 01:37:47 tvtime mythfrontend.real: mythfrontend[4077]: N thread_unknown mythdirs.cpp:205 (InitializeMythDirs) Using configuration directory = /home/wes/.mythtv
Jun  4 01:37:47 tvtime mythfrontend.real: mythfrontend[4077]: I Logger logging.cpp:280 (run) Added logging to the console
Jun  4 01:37:47 tvtime mythfrontend.real: mythfrontend[4077]: I CoreContext mythcorecontext.cpp:285 (Init) Assumed character encoding: en_US.UTF-8
Jun  4 01:37:47 tvtime mythfrontend.real: mythfrontend[4077]: I LogForward loggingserver.cpp:248 (SyslogLogger) Added syslogging
Jun  4 01:37:47 tvtime mythfrontend.real: mythfrontend[4077]: I CoreContext mythtranslation.cpp:64 (load) Loading en_us translation for module mythfrontend
Jun  4 01:37:47 tvtime mythfrontend.real: mythfrontend[4077]: I CoreContext mythcontext.cpp:629 (LoadDatabaseSettings) Empty LocalHostName. This is typical.
Jun  4 01:37:47 tvtime mythfrontend.real: mythfrontend[4077]: I CoreContext mythcontext.cpp:638 (LoadDatabaseSettings) Using a profile name of: 'tvtime' (Usually the same as this host's name.)
Jun  4 01:37:47 tvtime mythfrontend.real: mythfrontend[4077]: I CoreContext mythcontext.cpp:887 (TestDBconnection) Start up testing connections. DB localhost, BE , attempt 0, status dbAwake, Delay: 2000
Jun  4 01:37:48 tvtime mythfrontend.real: mythfrontend[4077]: N CoreContext mythcorecontext.cpp:1810 (InitLocale) Setting QT default locale to en_US
Jun  4 01:37:48 tvtime mythfrontend.real: mythfrontend[4077]: I CoreContext mythcorecontext.cpp:1843 (SaveLocaleDefaults) Current locale en_US
Jun  4 01:37:48 tvtime mythfrontend.real: mythfrontend[4077]: N CoreContext mythlocale.cpp:122 (LoadDefaultsFromXML) Reading locale defaults from /usr/share/mythtv//locales/en_us.xml
Jun  4 01:37:48 tvtime mythfrontend.real: mythfrontend[4077]: I CoreContext mythdisplay.cpp:341 (GetDesiredScreen) Display: Found screen 'HDMI1'
Jun  4 01:37:48 tvtime mythfrontend.real: mythfrontend[4077]: I CoreContext mythdisplay.cpp:477 (DebugScreen) Display: Using screen 'HDMI1' (Make: VIZIO, Inc Model: E390i-B1E-)
Jun  4 01:37:48 tvtime mythfrontend.real: mythfrontend[4077]: I CoreContext mythdisplay.cpp:481 (DebugScreen) Display: Geometry: 1920x1080+0+0 Size(Qt): 850mmx480mm
Jun  4 01:37:48 tvtime mythfrontend.real: mythfrontend[4077]: N CoreContext mythdisplay.cpp:506 (Initialise) Display: Desktop video mode: 1920x1080 60.000Hz
Jun  4 01:37:48 tvtime mythfrontend.real: mythfrontend[4077]: N CoreContext mythdisplay.cpp:512 (Initialise) Display: Display has custom colourspace
Jun  4 01:37:48 tvtime mythfrontend.real: mythfrontend[4077]: I SystemSignalManager mythsystemunix.cpp:488 (run) Starting process signal handler
Jun  4 01:37:48 tvtime mythfrontend.real: mythfrontend[4077]: I SystemIOHandlerR mythsystemunix.cpp:83 (run) Starting IO manager (read)
Jun  4 01:37:48 tvtime mythfrontend.real: mythfrontend[4077]: I SystemIOHandlerW mythsystemunix.cpp:83 (run) Starting IO manager (write)
Jun  4 01:37:48 tvtime mythfrontend.real: mythfrontend[4077]: I SystemManager mythsystemunix.cpp:262 (run) Starting process manager
Jun  4 01:37:48 tvtime mythfrontend.real: mythfrontend[4077]: I CoreContext screensaver-x11.cpp:78 (ScreenSaverX11Private) ScreenSaverX11Private: DPMS is disabled.
Jun  4 01:37:48 tvtime mythfrontend.real: mythfrontend[4077]: I CoreContext platforms/mythpowerdbus.cpp:360 (DeviceAdded) PowerDBus: Added UPower.Device '/org/freedesktop/UPower/devices/mouse_hidpp_battery_0'
Jun  4 01:37:48 tvtime mythfrontend.real: mythfrontend[4077]: I CoreContext mythpower.cpp:348 (PowerLevelChanged) Power: On AC power
Jun  4 01:37:48 tvtime mythfrontend.real: mythfrontend[4077]: I CoreContext mythpower.cpp:131 (Init) Power: Supported actions: Suspend,Restart,Shutdown
Jun  4 01:37:48 tvtime mythfrontend.real: mythfrontend[4077]: I CoreContext serverpool.cpp:419 (listen) Listening on TCP 0.0.0.0:6547
Jun  4 01:37:48 tvtime mythfrontend.real: mythfrontend[4077]: I CoreContext serverpool.cpp:419 (listen) Listening on TCP [::]:6547
Jun  4 01:37:52 tvtime mythfrontend.real: mythfrontend[4077]: I CoreContext mythtranslation.cpp:64 (load) Loading en_us translation for module mythfrontend
Jun  4 01:37:52 tvtime mythfrontend.real: mythfrontend[4077]: I CoreContext mythdisplay.cpp:708 (SwitchToGUI) Display: Using 1920x1080@60Hz for GUI
Jun  4 01:37:52 tvtime mythfrontend.real: mythfrontend[4077]: E CoreContext lirc.cpp:201 (Init) LIRC: Failed to connect to Unix socket '/var/run/lirc/lircd'#012#011#011#011eno: No such file or directory (2)
Jun  4 01:37:52 tvtime mythfrontend.real: mythfrontend[4077]: I CoreContext jsmenu.cpp:140 (ReadConfig) No joystick configuration found, not enabling joystick control
Jun  4 01:37:52 tvtime mythfrontend.real: mythfrontend[4077]: I CoreContext mythudplistener.cpp:32 (Enable) UDPListener: Enabling
Jun  4 01:37:52 tvtime mythfrontend.real: mythfrontend[4077]: I CoreContext serverpool.cpp:543 (bind) Binding to UDP 0.0.0.0:6948
Jun  4 01:37:52 tvtime mythfrontend.real: mythfrontend[4077]: I CoreContext serverpool.cpp:543 (bind) Binding to UDP [::]:6948
Jun  4 01:37:52 tvtime mythfrontend.real: mythfrontend[4077]: I CoreContext mythmainwindow.cpp:1009 (Init) Using Frameless Window
Jun  4 01:37:52 tvtime mythfrontend.real: mythfrontend[4077]: I CoreContext mythmainwindow.cpp:1025 (Init) Using Full Screen Window
Jun  4 01:37:52 tvtime mythfrontend.real: mythfrontend[4077]: I CoreContext mythdisplay.cpp:227 (SetWidget) Display: Have main widget
Jun  4 01:37:52 tvtime mythfrontend.real: mythfrontend[4077]: I CoreContext mythdisplay.cpp:231 (SetWidget) Display: Have main window
Jun  4 01:37:52 tvtime mythfrontend.real: mythfrontend[4077]: I CoreContext mythdisplay.cpp:341 (GetDesiredScreen) Display: Found screen 'HDMI1'
Jun  4 01:37:52 tvtime mythfrontend.real: mythfrontend[4077]: I CoreContext mythmainwindow.cpp:1058 (Init) UI Screen Resolution: 1920 x 1080
Jun  4 01:37:53 tvtime mythfrontend.real: mythfrontend[4077]: I CoreContext opengl/mythrenderopengl.cpp:421 (DebugFeatures) OpenGL: OpenGL vendor        : Intel
Jun  4 01:37:53 tvtime mythfrontend.real: mythfrontend[4077]: I CoreContext opengl/mythrenderopengl.cpp:422 (DebugFeatures) OpenGL: OpenGL renderer      : Mesa Intel(R) UHD Graphics 630 (CFL GT2)
Jun  4 01:37:53 tvtime mythfrontend.real: mythfrontend[4077]: I CoreContext opengl/mythrenderopengl.cpp:423 (DebugFeatures) OpenGL: OpenGL version       : 4.6 (Compatibility Profile) Mesa 20.0.4
Jun  4 01:37:53 tvtime mythfrontend.real: mythfrontend[4077]: I CoreContext opengl/mythrenderopengl.cpp:424 (DebugFeatures) OpenGL: Qt platform          : xcb
Jun  4 01:37:53 tvtime mythfrontend.real: mythfrontend[4077]: I CoreContext opengl/mythrenderopengl.cpp:427 (DebugFeatures) OpenGL: EGL display          : Yes
Jun  4 01:37:53 tvtime mythfrontend.real: mythfrontend[4077]: I CoreContext opengl/mythrenderopengl.cpp:428 (DebugFeatures) OpenGL: EGL images           : Yes
Jun  4 01:37:53 tvtime mythfrontend.real: mythfrontend[4077]: I CoreContext opengl/mythrenderopengl.cpp:430 (DebugFeatures) OpenGL: Qt OpenGL format     : OpenGL 4.6
Jun  4 01:37:53 tvtime mythfrontend.real: mythfrontend[4077]: I CoreContext opengl/mythrenderopengl.cpp:431 (DebugFeatures) OpenGL: Qt OpenGL surface    : RGBA: 8880 Depth: 0 Stencil: 0
Jun  4 01:37:53 tvtime mythfrontend.real: mythfrontend[4077]: I CoreContext opengl/mythrenderopengl.cpp:432 (DebugFeatures) OpenGL: Max texture size     : 16384
Jun  4 01:37:53 tvtime mythfrontend.real: mythfrontend[4077]: I CoreContext opengl/mythrenderopengl.cpp:433 (DebugFeatures) OpenGL: Max texture units    : 192
Jun  4 01:37:53 tvtime mythfrontend.real: mythfrontend[4077]: I CoreContext opengl/mythrenderopengl.cpp:434 (DebugFeatures) OpenGL: Shaders              : Yes
Jun  4 01:37:53 tvtime mythfrontend.real: mythfrontend[4077]: I CoreContext opengl/mythrenderopengl.cpp:435 (DebugFeatures) OpenGL: NPOT textures        : Yes
Jun  4 01:37:53 tvtime mythfrontend.real: mythfrontend[4077]: I CoreContext opengl/mythrenderopengl.cpp:436 (DebugFeatures) OpenGL: Multitexturing       : Yes
Jun  4 01:37:53 tvtime mythfrontend.real: mythfrontend[4077]: I CoreContext opengl/mythrenderopengl.cpp:437 (DebugFeatures) OpenGL: Rectangular textures : Yes
Jun  4 01:37:53 tvtime mythfrontend.real: mythfrontend[4077]: I CoreContext opengl/mythrenderopengl.cpp:439 (DebugFeatures) OpenGL: Buffer mapping       : Yes
Jun  4 01:37:53 tvtime mythfrontend.real: mythfrontend[4077]: I CoreContext opengl/mythrenderopengl.cpp:440 (DebugFeatures) OpenGL: Framebuffer objects  : Yes
Jun  4 01:37:53 tvtime mythfrontend.real: mythfrontend[4077]: I CoreContext opengl/mythrenderopengl.cpp:441 (DebugFeatures) OpenGL: 16bit framebuffers   : Yes
Jun  4 01:37:53 tvtime mythfrontend.real: mythfrontend[4077]: I CoreContext opengl/mythrenderopengl.cpp:442 (DebugFeatures) OpenGL: Unpack Subimage      : Yes
Jun  4 01:37:53 tvtime mythfrontend.real: mythfrontend[4077]: I CoreContext opengl/mythrenderopengl.cpp:443 (DebugFeatures) OpenGL: GL_RED/GL_R8         : Yes
Jun  4 01:37:53 tvtime mythfrontend.real: mythfrontend[4077]: I CoreContext opengl/mythrenderopengl.cpp:398 (Init) OpenGL: Initialised MythRenderOpenGL
Jun  4 01:37:53 tvtime mythfrontend.real: mythfrontend[4077]: I CoreContext opengl/mythrenderopengl.cpp:399 (Init) OpenGL: Using full range output
Jun  4 01:37:53 tvtime mythfrontend.real: mythfrontend[4077]: I CoreContext mythuihelper.cpp:763 (PruneCacheDir) MythUIHelper: Pruning cache directory: /home/wes/.mythtv/cache/remotecache
Jun  4 01:37:53 tvtime mythfrontend.real: mythfrontend[4077]: I CoreContext mythuihelper.cpp:821 (PruneCacheDir) MythUIHelper: Kept 102 files, deleted 0 files, stat error on 0 files
Jun  4 01:37:53 tvtime mythfrontend.real: mythfrontend[4077]: I CoreContext mythuihelper.cpp:763 (PruneCacheDir) MythUIHelper: Pruning cache directory: /home/wes/.mythtv/cache/thumbnails
Jun  4 01:37:53 tvtime mythfrontend.real: mythfrontend[4077]: I CoreContext mythuihelper.cpp:821 (PruneCacheDir) MythUIHelper: Kept 198 files, deleted 0 files, stat error on 0 files
Jun  4 01:37:53 tvtime mythfrontend.real: mythfrontend[4077]: I SendMessage mythcorecontext.cpp:471 (ConnectCommandSocket) MythCoreContext::ConnectCommandSocket(): Connecting to backend server: 127.0.0.1:6543 (try 1 of 1)
Jun  4 01:37:53 tvtime mythfrontend.real: mythfrontend[4077]: I SendMessage mythcorecontext.cpp:1694 (CheckProtoVersion) MythCoreContext::CheckProtoVersion(): Using protocol version 91 BuzzOff
Jun  4 01:37:53 tvtime mythfrontend.real: mythfrontend[4077]: I CoreContext devices/mythcecadapter.cpp:93 (Open) CECAdapter: libCEC support is disabled.
Jun  4 01:37:53 tvtime mythfrontend.real: mythfrontend[4077]: I CoreContext schemawizard.cpp:119 (Compare) Current MythTV Schema Version (DBSchemaVer): 1361
Jun  4 01:37:53 tvtime mythfrontend.real: mythfrontend[4077]: I CoreContext decoders/mythvdpauhelper.cpp:71 (HaveVDPAU) VDPAUHelp: VDPAU is NOT available
Jun  4 01:37:53 tvtime mythfrontend.real: mythfrontend[4077]: I CoreContext decoders/mythvaapicontext.cpp:481 (HaveVAAPI) VAAPIDec: Supported/available VAAPI decoders:
Jun  4 01:37:53 tvtime mythfrontend.real: mythfrontend[4077]: I CoreContext decoders/mythvaapicontext.cpp:615 (GetProfiles) VAAPIDec: EGL DMABUF available for best VAAPI performance
Jun  4 01:37:53 tvtime mythfrontend.real: mythfrontend[4077]: I CoreContext decoders/mythvaapicontext.cpp:488 (HaveVAAPI) VAAPIDec: MPEG2 Simple (Max size: 2048x2048)
Jun  4 01:37:53 tvtime mythfrontend.real: mythfrontend[4077]: I CoreContext decoders/mythvaapicontext.cpp:488 (HaveVAAPI) VAAPIDec: MPEG2 Main (Max size: 2048x2048)
Jun  4 01:37:53 tvtime mythfrontend.real: mythfrontend[4077]: I CoreContext decoders/mythvaapicontext.cpp:488 (HaveVAAPI) VAAPIDec: H264 Main (Max size: 4096x4096)
Jun  4 01:37:53 tvtime mythfrontend.real: mythfrontend[4077]: I CoreContext decoders/mythvaapicontext.cpp:488 (HaveVAAPI) VAAPIDec: H264 High (Max size: 4096x4096)
Jun  4 01:37:53 tvtime mythfrontend.real: mythfrontend[4077]: I CoreContext decoders/mythvaapicontext.cpp:488 (HaveVAAPI) VAAPIDec: VC1 Simple (Max size: 3840x3840)
Jun  4 01:37:53 tvtime mythfrontend.real: mythfrontend[4077]: I CoreContext decoders/mythvaapicontext.cpp:488 (HaveVAAPI) VAAPIDec: VC1 Main (Max size: 3840x3840)
Jun  4 01:37:53 tvtime mythfrontend.real: mythfrontend[4077]: I CoreContext decoders/mythvaapicontext.cpp:488 (HaveVAAPI) VAAPIDec: VC1 Advanced (Max size: 3840x3840)
Jun  4 01:37:53 tvtime mythfrontend.real: mythfrontend[4077]: I CoreContext decoders/mythvaapicontext.cpp:488 (HaveVAAPI) VAAPIDec: H264 Constrained (Max size: 4096x4096)
Jun  4 01:37:53 tvtime mythfrontend.real: mythfrontend[4077]: I CoreContext decoders/mythvaapicontext.cpp:488 (HaveVAAPI) VAAPIDec: VP8 (Max size: 4096x4096)
Jun  4 01:37:53 tvtime mythfrontend.real: mythfrontend[4077]: I CoreContext decoders/mythvaapicontext.cpp:488 (HaveVAAPI) VAAPIDec: HEVC Main (Max size: 8192x8192)
Jun  4 01:37:53 tvtime mythfrontend.real: mythfrontend[4077]: I CoreContext decoders/mythvaapicontext.cpp:488 (HaveVAAPI) VAAPIDec: HEVC Main10 (Max size: 8192x8192)
Jun  4 01:37:53 tvtime mythfrontend.real: mythfrontend[4077]: I CoreContext decoders/mythvaapicontext.cpp:488 (HaveVAAPI) VAAPIDec: VP9 Level 0 (Max size: 8192x8192)
Jun  4 01:37:53 tvtime mythfrontend.real: mythfrontend[4077]: I CoreContext decoders/mythvaapicontext.cpp:488 (HaveVAAPI) VAAPIDec: VP9 Level 2 (Max size: 8192x8192)
Jun  4 01:37:53 tvtime mythfrontend.real: mythfrontend[4077]: I CoreContext decoders/mythnvdeccontext.cpp:539 (HaveNVDEC) NVDEC: No NVDEC decoders found
Jun  4 01:37:53 tvtime mythfrontend.real: mythfrontend[4077]: I CoreContext decoders/mythv4l2m2mcontext.cpp:378 (HaveV4L2Codecs) V4L2_M2M: No V4L2 decoders found
Jun  4 01:37:53 tvtime mythfrontend.real: mythfrontend[4077]: N CoreContext mythmainwindow.cpp:1898 (RegisterMediaPlugin) Registering Internal as a media playback plugin.
Jun  4 01:37:53 tvtime mythfrontend.real: mythfrontend[4077]: A CoreContext mediamonitor-unix.cpp:206 (CheckMountable) MMUnix:CheckMountable: DBus interface error: The name org.freedesktop.UDisks was not provided by any .service files
Jun  4 01:37:53 tvtime mythfrontend.real: mythfrontend[4077]: W CoreContext mediamonitor-unix.cpp:213 (CheckMountable) MMUnix:UDisks2 service found. Media Monitor does not support this yet!
Jun  4 01:37:53 tvtime mythfrontend.real: mythfrontend[4077]: W CoreContext mythplugin.cpp:124 (MythPluginManager) No plugins directory /usr/lib/mythtv/plugins
Jun  4 01:37:53 tvtime mythfrontend.real: mythfrontend[4077]: N CoreContext main.cpp:1225 (RunMenu) Found mainmenu.xml for theme 'Functionality_mod'
Jun  4 01:37:53 tvtime mythfrontend.real: mythfrontend[4077]: I CoreContext housekeeper.cpp:664 (RegisterTask) Registering HouseKeeperTask 'HardwareProfiler'.
Jun  4 01:37:53 tvtime mythfrontend.real: mythfrontend[4077]: I CoreContext housekeeper.cpp:730 (Start) Queueing HouseKeeperTask 'HardwareProfiler'.
Jun  4 01:37:53 tvtime mythfrontend.real: mythfrontend[4077]: I CoreContext housekeeper.cpp:737 (Start) Starting HouseKeeper.
wmorrison
Senior
Posts: 165
Joined: Sat Dec 01, 2018 12:05 am
United States of America

Re: Help, Mysql (MariaDB?) not starting after upgrading Xubuntu to 20.04

Post by wmorrison »

As of this morning, I see the system is starting up on schedule, recording, and shutting down afterward. So I'm not missing any recordings, I just can't watch them until I fix mythfrontend.
wmorrison
Senior
Posts: 165
Joined: Sat Dec 01, 2018 12:05 am
United States of America

Re: Help, Mysql (MariaDB?) not starting after upgrading Xubuntu to 20.04

Post by wmorrison »

OK, it's got to be related to video, drivers or codecs or something. Both VLC and MPV crash when trying to play a video that worked fine before the upgrade.

mpv says:

Code: Select all

[ffmpeg] AVHWDeviceContext: Failed to query surface attributes: 20 (the requested function is not implemented).
[vo/gpu/vaapi-egl] failed to retrieve libavutil frame constraints
Using hardware decoding (vaapi).
AO: [pulse] 48000Hz stereo 2ch float
VO: [gpu] 1280x720 => 1280x947 vaapi[nv12]
Segmentation fault
wmorrison
Senior
Posts: 165
Joined: Sat Dec 01, 2018 12:05 am
United States of America

Re: Help, Mysql (MariaDB?) not starting after upgrading Xubuntu to 20.04

Post by wmorrison »

This is very frustrating. No idea how to fix this. At this point it's not a MythTV problem specifically, because other programs also crash playing video, that worked fine before.

mpv crashes, I think it uses hardware acceleration.
vlc crashes, even when I disable acceleration.
chrome works for streaming video, so I can at least watch netflix etc. until I fix this.
mplayer works. I think it does not use hardware acceleration. So I go to localhost:6544, find a show, download the .ts and play it with mplayer.
User avatar
bill6502
Developer
Posts: 2325
Joined: Fri Feb 07, 2014 5:28 pm
United States of America

Re: Help, Mysql (MariaDB?) not starting after upgrading Xubuntu to 20.04

Post by bill6502 »

I spun up 19.10 today. When I added the mythtv package, MySQL v8.0 came with.

I started the upgrade to 20.04, just to see if MariaDB replaces MySQL. It didn't.
Also, the mythtv and mysql packages weren't in the list of deleted packages.
Tomorrow, I'll actually perform the upgrade to see if the above can be duplicated.
So far, sorry to say, I haven't been able to reproduce the MariaDB issue.

Looks like your hardware is Intel, as is mine. vainfo looks like this:

Code: Select all

$ vainfo 
libva info: VA-API version 1.7.0
libva info: Trying to open /usr/lib/x86_64-linux-gnu/dri/iHD_drv_video.so
libva info: Found init function __vaDriverInit_1_7
libva error: /usr/lib/x86_64-linux-gnu/dri/iHD_drv_video.so init failed
libva info: va_openDriver() returns 1
libva info: Trying to open /usr/lib/x86_64-linux-gnu/dri/i965_drv_video.so
libva info: Found init function __vaDriverInit_1_6
libva info: va_openDriver() returns 0
vainfo: VA-API version: 1.7 (libva 2.6.0)
vainfo: Driver version: Intel i965 driver for Intel(R) Haswell Desktop - 2.4.0
vainfo: Supported profile and entrypoints
      VAProfileMPEG2Simple            :	VAEntrypointVLD
      VAProfileMPEG2Simple            :	VAEntrypointEncSlice
      VAProfileMPEG2Main              :	VAEntrypointVLD
      VAProfileMPEG2Main              :	VAEntrypointEncSlice
      VAProfileH264ConstrainedBaseline:	VAEntrypointVLD
      VAProfileH264ConstrainedBaseline:	VAEntrypointEncSlice
      VAProfileH264Main               :	VAEntrypointVLD
      VAProfileH264Main               :	VAEntrypointEncSlice
      VAProfileH264High               :	VAEntrypointVLD
      VAProfileH264High               :	VAEntrypointEncSlice
      VAProfileH264MultiviewHigh      :	VAEntrypointVLD
      VAProfileH264MultiviewHigh      :	VAEntrypointEncSlice
      VAProfileH264StereoHigh         :	VAEntrypointVLD
      VAProfileH264StereoHigh         :	VAEntrypointEncSlice
      VAProfileVC1Simple              :	VAEntrypointVLD
      VAProfileVC1Main                :	VAEntrypointVLD
      VAProfileVC1Advanced            :	VAEntrypointVLD
      VAProfileNone                   :	VAEntrypointVideoProc
      VAProfileJPEGBaseline           :	VAEntrypointVLD
wmorrison
Senior
Posts: 165
Joined: Sat Dec 01, 2018 12:05 am
United States of America

Re: Help, Mysql (MariaDB?) not starting after upgrading Xubuntu to 20.04

Post by wmorrison »

bill6502, thanks for taking the time to look into this. I know it's not explicitly a MythTV problem, but the problems I had getting to this point could be related to depends (referring mostly to the mysql/mariadb issues, not sure about video yet.)

Let me summarize where I started.

Last July or so, I started by installing "Xubuntu Core 19.04" from a live USB stick. I then installed MythTV 30. I don't remember whether I installed anything explicitly for database, but I don't think so. I kept up with updates while setting up the system, but once it was all working, probably mid-September, I stopped updating in general.

I have a timeshift backup from before I started upgrading. It's not completely "clean" as I had already found 19.04 was no longer in archive and modified my sources.list to point to old-releases and updated what I could. But the backup still has mythtv 30 and mysql 5.7.

Below I will paste some data extracted from the backups /var/lib/dpkg/status. All packages are "install ok installed." I can get more info from the backup if you want, but for this I extracted Package/Version/Depends/Breaks/Conflicts for any package with myth or mysql in the package name. (There were no mariadb packages installed, just listed in depends of other packages.)

Code: Select all

Package: default-mysql-server
Version: 1.0.5
Depends: mysql-server-5.7
Breaks: mysql-server (<< 5.7)

Package: libdbd-mysql-perl
Version: 4.050-2
Depends: perl (>= 5.28.1-4), perl-dbdabi-94, perlapi-5.28.1, libc6 (>= 2.4), libmysqlclient20 (>= 5.7.11), libdbi-perl

Package: libmysqlclient20
Version: 5.7.27-0ubuntu0.19.04.1
Depends: mysql-common (>= 5.5), libc6 (>= 2.29), libgcc1 (>= 1:3.0), libstdc++6 (>= 5.2), zlib1g (>= 1:1.1.4)

Package: libmyth
Version: 2:30.0+fixes.201909121531.0c9abf3~ubuntu19.04.1
Depends: libasound2 (>= 1.0.16), libass9 (>= 1:0.13.6), libavahi-compat-libdnssd1 (>= 0.6.16), libavc1394-0 (>= 0.5.3), libbluray2 (>= 1:0.9.0), libbz2-1.0, libc6 (>= 2.29), libcrystalhd3 (>= 1:0.0~git20110715.fdd2f19), libexiv2-14 (>= 0.25), libfftw3-double3 (>= 3.3.5), libfftw3-single3 (>= 3.3.5), libfreetype6 (>= 2.2.1), libgcc1 (>= 1:4.0), libgl1, libhdhomerun4, libiec61883-0 (>= 1.2.0), liblzma5 (>= 5.1.1alpha+20120614), liblzo2-2, libmp3lame0 (>= 3.100), libpulse0 (>= 0.99.1), libqt5core5a (>= 5.12.2), libqt5dbus5 (>= 5.0.2), libqt5gui5 (>= 5.10.0) | libqt5gui5-gles (>= 5.10.0), libqt5network5 (>= 5.5.0), libqt5opengl5 (>= 5.0.2), libqt5script5 (>= 5.6.0~beta), libqt5sql5 (>= 5.3.0), libqt5webkit5 (>= 5.6.0~rc), libqt5widgets5 (>= 5.11.0~rc1), libqt5xml5 (>= 5.1.0), libraw1394-11, libsamplerate0 (>= 0.1.7), libsdl2-2.0-0 (>= 2.0.9), libsndio7.0 (>= 1.1.0), libssl1.1 (>= 1.1.0), libstdc++6 (>= 7), libsystemd0, libtag1v5 (>= 1.11), libva-drm2 (>= 1.1.0), libva-glx2 (>= 1.0.3), libva-x11-2 (>= 1.0.3), libva2 (>= 2.2.0), libvdpau1 (>= 0.2), libvpx5 (>= 1.6.0), libx11-6, libx264-155, libxcb-shape0, libxcb-xfixes0, libxcb1, libxext6, libxinerama1, libxml2 (>= 2.7.4), libxnvctrl0, libxrandr2 (>= 4.3), libxv1, libxxf86vm1, zlib1g (>= 1:1.2.0.2), libqt5sql5-mysql
Conflicts: libmyth-0.23-0, libmyth-0.24-0, libmyth-0.25-0, libmyth-0.26-0, libmyth-0.27-0, libmyth-0.28-0, libmyth-0.29-0, libmyth-29-0, mythtv (<< 0.7-5)

Package: libmyth-python
Version: 2:30.0+fixes.201912012038.a27754a~ubuntu19.04.1
Depends: python-lxml, python:any (<< 2.8), python:any (>= 2.7~), python, python-mysqldb, python-urlgrabber
Conflicts: mythtv-common (<< 0.20.98)

Package: libmythtv-perl
Version: 2:30.0+fixes.201910161454.2855e29~ubuntu19.04.1
Depends: perl, libdbi-perl, libdbd-mysql-perl, libnet-upnp-perl, libio-socket-inet6-perl
Conflicts: libmyth-perl, mythtv-common (<< 0.20.98)

Package: libqt5sql5-mysql
Version: 5.12.2+dfsg-4ubuntu1.1
Depends: libc6 (>= 2.14), libmysqlclient20 (>= 5.7.11), libqt5core5a (>= 5.12.2), libqt5sql5 (>= 5.10.0), libstdc++6 (>= 5), qtbase-abi-5-12-2

Package: mysql-client-5.7
Version: 5.7.27-0ubuntu0.19.04.1
Depends: debianutils (>= 1.6), mysql-client-core-5.7, mysql-common (>= 5.5), libc6 (>= 2.29), libgcc1 (>= 1:3.0), liblz4-1 (>= 0.0~r127), libstdc++6 (>= 5.2), zlib1g (>= 1:1.1.4)
Breaks: mysql-client-5.6 (<< 5.7), mysql-server-core-5.6 (<< 5.6.22-1~)
Conflicts: mysql-client-5.5, virtual-mysql-client

Package: mysql-client-core-5.7
Version: 5.7.27-0ubuntu0.19.04.1
Depends: libaio1 (>= 0.3.93), libc6 (>= 2.29), libedit2 (>= 2.11-20080614-0), libgcc1 (>= 1:4.0), liblz4-1 (>= 0.0~r130), libnuma1 (>= 2.0.11), libstdc++6 (>= 5.2), zlib1g (>= 1:1.2.0)
Breaks: mysql-client-core-5.6 (<< 5.7)
Conflicts: mysql-client-5.5, mysql-client-core-5.5, virtual-mysql-client-core

Package: mysql-common
Version: 5.8+1.0.5
Breaks: mariadb-common (<< 10.0.20-3~)
Conflicts: mariadb-server-5.5, mysql-common-5.6, mysql-server-5.5, percona-xtradb-cluster-common-5.5

Package: mysql-server-5.7
Version: 5.7.27-0ubuntu0.19.04.1
Depends: lsb-base (>= 3.0-10), mysql-client-5.7 (>= 5.7.27-0ubuntu0.19.04.1), mysql-common (>= 5.8+1.0.4~), mysql-server-core-5.7 (= 5.7.27-0ubuntu0.19.04.1), passwd, perl (>= 5.6), psmisc, debconf (>= 0.5) | debconf-2.0, libc6 (>= 2.29), libevent-core-2.1-6 (>= 2.1.8-stable), libgcc1 (>= 1:3.0), liblz4-1 (>= 0.0~r127), libmecab2, libstdc++6 (>= 5.2), zlib1g (>= 1:1.1.4)
Breaks: mysql-server-5.6 (<< 5.7)
Conflicts: mysql-client-5.5, mysql-server-5.5, virtual-mysql-server

Package: mysql-server-core-5.7
Version: 5.7.27-0ubuntu0.19.04.1
Depends: libaio1 (>= 0.3.93), libc6 (>= 2.29), libgcc1 (>= 1:4.0), liblz4-1 (>= 0.0~r130), libnuma1 (>= 2.0.11), libstdc++6 (>= 5.2), libwrap0 (>= 7.6-4~), zlib1g (>= 1:1.2.0)
Breaks: mariadb-client-10.0 (<< 10.0.16-2~), mysql-client-5.6 (<< 5.6.22-1~), mysql-server-5.5, mysql-server-5.6 (<< 5.6.25-3~), mysql-server-core-5.6 (<< 5.7)
Conflicts: mysql-client-5.5 (<< 5.6), mysql-server-core-5.5, virtual-mysql-server-core

Package: mysql-utilities
Version: 1.6.4-1
Depends: python:any (<< 2.8), python:any (>= 2.7.5-5~), python-mysql.connector (>= 1.2.1)
Breaks: libmysql-diff-perl (<< 0.43-2)

Package: mythtv
Version: 2:30.0+fixes.201909121531.0c9abf3~ubuntu19.04.1
Depends: default-mysql-server | virtual-mysql-server | mysql-server-5.7 | mysql-server-5.6 | mariadb-server, mythtv-database, mythtv-frontend, mythtv-backend, ntp | time-daemon | ntp-simple

Package: mythtv-backend
Version: 2:30.0+fixes.201909121531.0c9abf3~ubuntu19.04.1
Depends: mythtv-common, mythtv-transcode-utils, libc6 (>= 2.29), libgcc1 (>= 1:3.0), libmyth (>= 2:30.0+fixes.201909121531.0c9abf3~ubuntu19.04.1), libqt5core5a (>= 5.12.2), libqt5gui5 (>= 5.0.2) | libqt5gui5-gles (>= 5.0.2), libqt5network5 (>= 5.0.2), libqt5script5 (>= 5.6.0~beta), libqt5sql5 (>= 5.0.2), libqt5widgets5 (>= 5.0.2), libqt5xml5 (>= 5.0.2), libstdc++6 (>= 6), libsystemd0, cron, wget, zenity | kdebase-bin, xterm, python, libjs-jquery, libxml-simple-perl
Conflicts: mythtv (<< 0.8-1)

Package: mythtv-common
Version: 2:30.0+fixes.201909121531.0c9abf3~ubuntu19.04.1
Depends: adduser, default-mysql-client | virtual-mysql-client | mysql-client-5.7 | mysql-client-5.6 | mariadb-client, fonts-liberation | ttf-liberation, fonts-droid-fallback | fonts-droid | ttf-droid, ttf-dejavu, fonts-tlwg-purisa, fonts-texgyre | tex-gyre, python, libxml-xpath-perl, pciutils, usbutils, python-future, python-requests, python-requests-cache, libc6 (>= 2.29), libgcc1 (>= 1:3.0), libmyth (>= 2:30.0+fixes.201909121531.0c9abf3~ubuntu19.04.1), libqt5core5a (>= 5.12.2), libqt5gui5 (>= 5.0.2) | libqt5gui5-gles (>= 5.0.2), libqt5network5 (>= 5.0.2), libqt5sql5 (>= 5.0.2), libqt5xml5 (>= 5.0.2), libsdl2-2.0-0 (>= 2.0.9), libstdc++6 (>= 4.1.1), debconf (>= 0.5) | debconf-2.0
Breaks: mythtv-backend (<< 2:0.28.0~master.20150106.b8b9a1e-0ubuntu0mythbuntu4), mythtv-frontend (<< 2:0.28.0+fixes.20161010.38d9ba2-0ubuntu0mythbuntu4), mythvideo
Conflicts: mythcontrols, mythmusic (<< 0.20.99+trunk14393), mythtv (<< 0.8-1), mythtv-theme-blootube, mythtv-theme-blootube-wide, mythtv-theme-blootubelite-wide, mythtv-theme-childish, mythtv-theme-glass-wide, mythtv-theme-gray-osd, mythtv-theme-isthmus, mythtv-theme-iulius, mythtv-theme-metallurgy, mythtv-theme-minimalist-wide, mythtv-theme-mythcenter, mythtv-theme-mythcenter-wide, mythtv-theme-neon-wide, mythtv-theme-proejctgrayhem-wide, mythtv-theme-projectgrayhem, mythtv-theme-retro, mythtv-theme-titivillus, mythtv-themes, mythweather (<< 0.20.99+trunk14393)

Package: mythtv-database
Version: 2:30.0+fixes.201909121531.0c9abf3~ubuntu19.04.1
Depends: mythtv-common, libdbd-mysql-perl, default-mysql-client | virtual-mysql-client | mysql-client-5.7 | mysql-client-5.6 | mariadb-client, cron, debconf (>= 0.5) | debconf-2.0
Conflicts: mythtv (<< 0.8-1), mythtv-common (<< 0.8-2)

Package: mythtv-dbg
Version: 2:30.0+fixes.201909121531.0c9abf3~ubuntu19.04.1
Depends: mythtv-backend (= 2:30.0+fixes.201909121531.0c9abf3~ubuntu19.04.1) | mythtv-frontend (= 2:30.0+fixes.201909121531.0c9abf3~ubuntu19.04.1)
Conflicts: mythplugins-dbg

Package: mythtv-frontend
Version: 2:30.0+fixes.201909121531.0c9abf3~ubuntu19.04.1
Depends: mythtv-common, libc6 (>= 2.29), libgcc1 (>= 1:3.0), libmyth (>= 2:30.0+fixes.201909121531.0c9abf3~ubuntu19.04.1), libqt5core5a (>= 5.12.2), libqt5dbus5 (>= 5.0.2), libqt5gui5 (>= 5.0.2) | libqt5gui5-gles (>= 5.0.2), libqt5network5 (>= 5.0.2), libqt5script5 (>= 5.6.0~beta), libqt5sql5 (>= 5.0.2), libqt5widgets5 (>= 5.0.2), libqt5xml5 (>= 5.0.2), libstdc++6 (>= 5.2), libsystemd0, libnotify-bin, adduser, zenity | kdebase-bin, wmctrl, libxml-simple-perl, libwww-perl, libmyth-python, python, python-imdbpy | python3-imdbpy
Breaks: mythvideo
Conflicts: mythappearance (<< 0.21.0), mythflix (<< 0.23.0), mythstream (<< 0.21.0), mythtv (<< 0.8-1)

Package: mythtv-status
Version: 1.0.1-1
Depends: debconf (>= 0.5) | debconf-2.0, perl:any, libwww-perl, libxml-libxml-perl, libdate-manip-perl, libmime-tools-perl, lsb-base (>= 3.0-6)

Package: mythtv-transcode-utils
Version: 2:30.0+fixes.201909121531.0c9abf3~ubuntu19.04.1
Depends: mythtv-common, libc6 (>= 2.14), libgcc1 (>= 1:3.0), libmyth (>= 2:30.0+fixes.201909121531.0c9abf3~ubuntu19.04.1), libqt5core5a (>= 5.12.2), libqt5sql5 (>= 5.0.2), libstdc++6 (>= 4.1.1)
Conflicts: mythtv-backend (<< 0.20.2-0ubuntu1)

Package: python-mysql.connector
Version: 8.0.15-1
Depends: python-protobuf, python:any (<< 2.8), python:any (>= 2.7~)
Breaks: mysql-utilities (<< 1.3.5-2)

Package: python-mysqldb
Version: 1.3.10-2
Depends: python (<< 2.8), python (>= 2.7~), python:any (<< 2.8), python:any (>= 2.7~), libc6 (>= 2.4), libmysqlclient20 (>= 5.7.11)
So again, I couldn't upgrade from 19.04 directly to 20.04, had to upgrade to 19.10 first.

I suspect the problem is something like:

mythtv database depends are default-mysql-server | virtual-mysql-server | mysql-server-5.7 | mysql-server-5.6 | mariadb-server
default-mysql-server points to mysql-server-5.7
mysql-server-5.7 not available when upgrading OS, so based on mythtv depends it prefers mariadb over mysql-server-8.0

Does that sound right?

However, at this point I am past database issues and trying to solve video issues.
wmorrison
Senior
Posts: 165
Joined: Sat Dec 01, 2018 12:05 am
United States of America

Re: Help, Mysql (MariaDB?) not starting after upgrading Xubuntu to 20.04

Post by wmorrison »

So at this point, it's not a mythtv issue, it's video, so no worries if no answer here. But I'll still update with my findings, in case anyone else has a similar problem.

I tested with mpv, which supports various video output drivers with option -vo.

If I run mpv without specifying -vo, it prints "Using hardware decoding (vaapi)" and segfaults.

-vo=x11 says "Using hardware decoding (vaapi-copy)" and works. Hey! Copy? Maybe that's related to the problem (I never explicitly made a copy of anything related to vaapi.)

-vo=vaapi says "Using hardware decoding (vaapi)" and works.

-vo=gpu says "Using hardware decoding (vaapi)" and segfaults.

Maybe there are somehow two copies of vaapi and it confuses applications looking to use the gpu?
wmorrison
Senior
Posts: 165
Joined: Sat Dec 01, 2018 12:05 am
United States of America

Re: Help, Mysql (MariaDB?) not starting after upgrading Xubuntu to 20.04

Post by wmorrison »

bill6502, what kernel are you on?

I found a page they says "there is something in the 5.4 kernel that causes hangs on Intel iGPUs."

https://www.reddit.com/r/archlinux/comm ... om_freeze/

My kernel:
Linux 5.4.0-33-generic #37-Ubuntu SMP Thu May 21 12:53:59 UTC 2020
User avatar
bill6502
Developer
Posts: 2325
Joined: Fri Feb 07, 2014 5:28 pm
United States of America

Re: Help, Mysql (MariaDB?) not starting after upgrading Xubuntu to 20.04

Post by bill6502 »

Ubuntu 5.4.0-33.37-generic. Interesting as I'm in the middle of upgrading that 19.10
host to 20.04 and in the last few minutes, the screen went blank. Note that on the
same host, I'd already had a clean install of 20.04 running OK. I need to boot up
on the other 20.04 to verify that a recording can be played --- think it did.
wmorrison
Senior
Posts: 165
Joined: Sat Dec 01, 2018 12:05 am
United States of America

Re: Help, Mysql (MariaDB?) not starting after upgrading Xubuntu to 20.04

Post by wmorrison »

FIXED, graphics issue stopping mythwelcome/mythfrontend from running (segfaulting)

See this:

https://askubuntu.com/questions/1231824 ... untu-20-04

Read down to "Same problem here with an Intel UHD Graphics 630 (Desktop) after upgrading from 19.10 to 20.04."

I backed up my /etc/X11/xorg.conf.d/20-intel.conf file, rebooted, and everything is working. Desktop background color changed to gray, but who cares. Haven't noticed any other ill effects yet.

The page I linked described artifacts on the screen. I didn't notice anything like the pictures. I did notice a small black rectangle in the upper left corner of the screen when booting that went away. Maybe that's just how the "artifacts" presented on my system.

I had created that file last year for some reason or other, mainly for the TearFree option, I think. But I haven't seen any tearing in a few recordings I just tested.

mpv and vlc now work, too.
pletchtd
Newcomer
Posts: 4
Joined: Sat Mar 28, 2020 7:47 pm
United States of America

Re: Help, Mysql (MariaDB?) not starting after upgrading Xubuntu to 20.04

Post by pletchtd »

Hi WMorrison,

I posted about my experience upgrading 18.04 to 20.04 on the mythtv users mailing list http://lists.mythtv.org/pipermail/mytht ... 03432.html and experienced similar issues with opengl programs segfaulting including MythFrontend. If you read through the thread including my replies, I share a few different things you can do to address the problem that worked for me including one that allows you to keep using the legacy intel driver and a xorg.conf file if you have custom modelines or other reasons. In the end, I elected to just work through making everything work with the kernel modesetting driver.

One other thing to look out for is whether VAAPI acceleration is working properly in mythfronted. Check the log to see if validation of VAAPI deinterlacer is failing. The last post in the thread details the issue and I had to specify the legacy 965 driver rather than the iHD driver when starting mythfrontend.

Tim
Post Reply