[mythtv-users] MySQL won't start after an Ubuntu 20.04 Focal upgrade

Ken Yee kenkyee at yahoo.com
Sat Oct 10 20:50:54 UTC 2020

I don't seem to learn that I shouldn't upgrade Ubuntu but this time a full reinstall of MythTV isn't working :-(Has anyone seen this.  MythTV 31 was working fine w/ Ubuntu 18.04 but I can't get MySQL to start at all on Ubuntu 20.04.
Even did a hard purge of MythTV and deleted all /etc/mysql directories.systemctl and journal doesn't show anything useful.
During mythtv install, I get this which matches what shows up in systemctl logs:
Setting up libmyth (2:31.0+fixes.20200323.9579662cdc-0ubuntu1) ...Setting up libmyth-python (2:31.0+fixes.20200323.9579662cdc-0ubuntu1) .../usr/lib/python3/dist-packages/MythTV/database.py:1170: SyntaxWarning: "is" with a literal. Did you mean "=="?  if host is 'NULL':/usr/lib/python3/dist-packages/MythTV/system.py:134: SyntaxWarning: "is" with a literal. Did you mean "=="?  if self.path is '':/usr/lib/python3/dist-packages/MythTV/system.py:168: SyntaxWarning: "is" with a literal. Did you mean "=="?  if self.path is '':/usr/lib/python3/dist-packages/MythTV/system.py:444: SyntaxWarning: "is" with a literal. Did you mean "=="?  if self.path is '':Setting up mysql-server-8.0 (8.0.21-0ubuntu0.20.04.4) ...update-alternatives: using /etc/mysql/mysql.cnf to provide /etc/mysql/my.cnf (my.cnf) in auto modeRenaming removed key_buffer and myisam-recover options (if present)mysqld will log errors to /var/log/mysql/error.log2020-10-10T20:41:58.335392Z 0 [ERROR] [MY-010946] [Server] Failed to start mysqld daemon. Check mysqld error log.Warning: Unable to start the server.Created symlink /etc/systemd/system/multi-user.target.wants/mysql.service → /lib/systemd/system/mysql.service.Job for mysql.service failed because the control process exited with error code.See "systemctl status mysql.service" and "journalctl -xe" for details.invoke-rc.d: initscript mysql, action "start" failed.● mysql.service - MySQL Community Server     Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled)     Active: activating (auto-restart) (Result: exit-code) since Sat 2020-10-10 16:42:02 EDT; 7ms ago    Process: 83802 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=0/SUCCESS)    Process: 83810 ExecStart=/usr/sbin/mysqld (code=exited, status=1/FAILURE)   Main PID: 83810 (code=exited, status=1/FAILURE)     Status: "Server startup in progress"dpkg: error processing package mysql-server-8.0 (--configure): installed mysql-server-8.0 package post-installation script subprocess returned error exit status 1Setting up mythtv-common (2:31.0+fixes.20200323.9579662cdc-0ubuntu1) ...Setting up libmythtv-perl (2:31.0+fixes.20200323.9579662cdc-0ubuntu1) ...Setting up mythtv-transcode-utils (2:31.0+fixes.20200323.9579662cdc-0ubuntu1) ...Setting up mythtv-backend (2:31.0+fixes.20200323.9579662cdc-0ubuntu1) ...dpkg: dependency problems prevent configuration of default-mysql-server: default-mysql-server depends on mysql-server-8.0; however:  Package mysql-server-8.0 is not configured yet.
dpkg: error processing package default-mysql-server (--configure): dependency problems - leaving unconfiguredSetting up mythtv-frontend (2:31.0+fixes.20200323.9579662cdc-0ubuntu1) ...No apport report written because the error message indicates its a followup error from a previous failure.                                                                                                          dpkg: dependency problems prevent configuration of mythtv: mythtv depends on default-mysql-server | virtual-mysql-server | mysql-server-5.7 | mysql-server-5.6 | mariadb-se
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20201010/30a06074/attachment.htm>

More information about the mythtv-users mailing list