Comment 0 for bug 1576767

Upgrading from Mythbuntu 14.04 LTS / mythtv 0.28 to Mythbuntu 16.04 LTS / mythtv 0.28 and mythbuntu repositories disabled.

In Mythbuntu Control Centre, MySQL
"Enable MySQL performance tweaks" is selected.

Ran in terminal:
sudo update-manager -d

3) What you expected to happen
Not sure if this should be reported against mythbuntu-common or mythbuntu-control-centre but the expectation is that the mysql version be tested as part of the mythbuntu 0.28 install and the corrected mysql setting be included in the file.

4) What happened instead
Near the end of the upgrade, mysql server is started, and the /etc/mysql/conf.d/mythtv-tweaks.cnf file is invoked which contains the line
table_cache=128

According to
https://bugs.mysql.com/bug.php?id=68315
this is now deprecated, and table_open_cache replaces it.

The failure shows up in
/var/log/mysql/error.log
as
[ERROR] unknown variable 'table_cache=128'
[ERROR] Aborting

and mysql shuts down.
It then continues to start up mysql and shutdown again in a continues loop, effectively hanging.
The process must be killed and intervention is required to complete the upgrade.

1) The release of Ubuntu you are using, via 'lsb_release -rd' or System -> About Ubuntu
pvruser@pvr:~$ lsb_release -rd
Description: Ubuntu 16.04 LTS
Release: 16.04

2) The version of the package you are using, via 'apt-cache policy pkgname' or by checking in Software Center
pvruser@pvr:~$ apt-cache policy mythbuntu-common
mythbuntu-common:
  Installed: 0.78.2
  Candidate: 0.78.2
  Version table:
 *** 0.78.2 500
        500 http://mirror.internode.on.net/pub/ubuntu/ubuntu xenial/universe i386 Packages
        100 /var/lib/dpkg/status

pvruser@pvr:~$ apt-cache policy mythbuntu-control-centre
mythbuntu-control-centre:
  Installed: 0.64.1
  Candidate: 0.64.1
  Version table:
 *** 0.64.1 500
        500 http://mirror.internode.on.net/pub/ubuntu/ubuntu xenial/universe i386 Packages
        100 /var/lib/dpkg/status

ProblemType: Bug
DistroRelease: Ubuntu 16.04
Package: mythbuntu-common 0.78.2
ProcVersionSignature: Ubuntu 3.13.0-85.129-generic 3.13.11-ckt36
Uname: Linux 3.13.0-85-generic i686
NonfreeKernelModules: nvidia
ApportVersion: 2.20.1-0ubuntu2
Architecture: i386
CurrentDesktop: XFCE
Date: Fri Apr 29 23:19:12 2016
InstallationDate: Installed on 2011-10-15 (1658 days ago)
InstallationMedia: Mythbuntu 10.04 LTS "Lucid Lynx" - Release i386 (20100427.1)
PackageArchitecture: all
SourcePackage: mythbuntu-common
UpgradeStatus: Upgraded to xenial on 2016-04-29 (0 days ago)