[Resolved] Resolved: Mythconverg won't start after DB Upgrade to MariaDB

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

Moderator: Forum Moderators

Post Reply
paul-tancove
Newcomer
Posts: 2
Joined: Sat May 01, 2021 4:38 pm
Great Britain

[Resolved] Resolved: Mythconverg won't start after DB Upgrade to MariaDB

Post by paul-tancove » Sat May 01, 2021 5:58 pm

I've just upgraded my Ubuntu 16.04 to 20.04 and still on mythtv 0.28 as having problems with Nvidia card. Software Updater ran this morning and installed MariaDB(?) and now the backend database will not start. Apparently, this was an upgrade from galera( who knew?). Best advice I found was to delete them both and re-install MariaDB. I deleted them and rebooted and then found out that I still have MYSQL 8.0 server and client installed as well but this isn't running either. Yesterday's logs show that MYSQL was loading, mentioning nothing about galera or Mariadb. Right from the 20.04 upgrade I was aware that mysql was being held back, presumably for mythtv 16.04. This has therefore come as a complete surprise and I'm not sure where to take this.
The journalctl log is

Code: Select all

May 01 15:53:27 PVR-1 audit[1017]: AVC apparmor="STATUS" operation="profile_load" profile="unconfined" name="/usr/sbin/mysqld" pid=1017 comm="apparmor_parser"

May 01 15:53:29 PVR-1 mythbackend[1221]: mythbackend[1221]: I thread_unknown signalhandling.cpp:194 (SetHandlerPrivate) Setup Illegal instruction handler
May 01 15:53:29 PVR-1 mythbackend[1221]: mythbackend[1221]: I thread_unknown signalhandling.cpp:194 (SetHandlerPrivate) Setup Real-time signal 0 handler
May 01 15:53:29 PVR-1 mythbackend[1221]: mythbackend[1221]: I thread_unknown signalhandling.cpp:194 (SetHandlerPrivate) Setup Hangup handler
May 01 15:53:29 PVR-1 mythbackend[1221]: mythbackend[1221]: N thread_unknown mythdirs.cpp:192 (InitializeMythDirs) Using runtime prefix = /usr
May 01 15:53:29 PVR-1 mythbackend[1221]: mythbackend[1221]: N thread_unknown mythdirs.cpp:194 (InitializeMythDirs) Using configuration directory = /home/mythtv/.mythtv
May 01 15:53:29 PVR-1 mythbackend[1221]: mythbackend[1221]: I CoreContext mythcorecontext.cpp:266 (Init) Assumed character encoding: en_GB.UTF-8
May 01 15:53:29 PVR-1 mythbackend[1221]: mythbackend[1221]: I Logger logging.cpp:313 (run) Added logging to the console
May 01 15:53:29 PVR-1 mythbackend[1221]: mythbackend[1221]: N CoreContext mythcontext.cpp:505 (LoadDatabaseSettings) Empty LocalHostName.
May 01 15:53:29 PVR-1 mythbackend[1221]: mythbackend[1221]: I CoreContext mythcontext.cpp:513 (LoadDatabaseSettings) Using localhost value of PVR-1
May 01 15:53:29 PVR-1 mythbackend[1221]: mythbackend[1221]: E CoreContext mythdbcon.cpp:229 (OpenDatabase) [DBManager0] Unable to connect to database!
May 01 15:53:29 PVR-1 mythbackend[1221]: mythbackend[1221]: E CoreContext mythdbcon.cpp:230 (OpenDatabase) Driver error was [1/2002]:
                                         QMYSQL: Unable to connect
                                         Database error was:
                                         Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
May 01 15:53:29 PVR-1 mythbackend[1221]: mythbackend[1221]: C CoreContext main.cpp:132 (main) Failed to init MythContext.
May 01 15:53:29 PVR-1 mythbackend[1221]: mythbackend[1221]: I LogForward loggingserver.cpp:295 (SyslogLogger) Added syslogging
May 01 15:53:29 PVR-1 mythbackend[1221]: mythbackend[1221]: E CoreContext mmulticastsocketdevice.cpp:60 (MMulticastSocketDevice) MMulticastSocketDevice(239.255.255.250:12): setsockopt - IP_ADD_MEMBERSHI>
eno: No such device (19)
Last edited by paul-tancove on Mon May 31, 2021 4:31 pm, edited 1 time in total.

paul-tancove
Newcomer
Posts: 2
Joined: Sat May 01, 2021 4:38 pm
Great Britain

Re: Mythconverg won't start after DB Upgrade to MariaDB

Post by paul-tancove » Mon May 31, 2021 4:26 pm

This issue is resolved, if that's the right word. I've overwritten Ubuntu 20.04 with 18.04, saving user data and settings, installed mythtv v30.0 and overwritten the database from the 0.28 database backup. I now have a working mythtv box again apart from:-
Only 2 tuners working out of 4
Can't use Nvidia card for vdpau
Mythtv won't use the HDMI CEC adapter

Still plenty to work on then.

Post Reply