← Back to team overview

mythbuntu-bugs team mailing list archive

[Bug 1576767] [NEW] Mythbuntu 16.04 LTS upgrade fails due to mythtv-tweaks.cnf for mysql

 

Public bug reported:

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)

** Affects: mythbuntu-common (Ubuntu)
     Importance: Undecided
         Status: New


** Tags: apport-bug i386 third-party-packages xenial

** Attachment added: "error.log.bug-report"
   https://bugs.launchpad.net/bugs/1576767/+attachment/4651491/+files/error.log.bug-report

-- 
You received this bug notification because you are a member of Mythbuntu
Bug Team, which is subscribed to mythbuntu-common in Ubuntu.
https://bugs.launchpad.net/bugs/1576767

Title:
  Mythbuntu 16.04 LTS upgrade fails due to mythtv-tweaks.cnf for mysql

Status in mythbuntu-common package in Ubuntu:
  New

Bug description:
  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)

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/mythbuntu-common/+bug/1576767/+subscriptions


Follow ups