[Resolved] Resolved: Mythconverg won't start after DB Upgrade to MariaDB
Posted: 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
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)