Mythbuntu 16.04 LTS upgrade fails due to mythtv-tweaks.cnf for mysql
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Mythbuntu |
Fix Released
|
Medium
|
Thomas Mashos | ||
16.04 |
Won't Fix
|
Undecided
|
Unassigned | ||
16.10 |
Won't Fix
|
Undecided
|
Unassigned | ||
mythbuntu-common (Ubuntu) |
Fix Released
|
Medium
|
Thomas Mashos |
Bug Description
[Impact]
Using the Mythtv tweaks for MySQL in the Mythbuntu-
[Test Case]
Enable the "MySQL performance tweaks" inside Mythbuntu-
[Regression Potential]
Low. This is currently causing MySQL to not start when applied, so in the event of a regression it would just continue to not start.
Original Descrition:
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-
4) What happened instead
Near the end of the upgrade, mysql server is started, and the /etc/mysql/
table_cache=128
According to
https:/
this is now deprecated, and table_open_cache replaces it.
The failure shows up in
/var/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://
100 /var/lib/
pvruser@pvr:~$ apt-cache policy mythbuntu-
mythbuntu-
Installed: 0.64.1
Candidate: 0.64.1
Version table:
*** 0.64.1 500
500 http://
100 /var/lib/
ProblemType: Bug
DistroRelease: Ubuntu 16.04
Package: mythbuntu-common 0.78.2
ProcVersionSign
Uname: Linux 3.13.0-85-generic i686
NonfreeKernelMo
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)
PackageArchitec
SourcePackage: mythbuntu-common
UpgradeStatus: Upgraded to xenial on 2016-04-29 (0 days ago)
Related branches
Changed in mythbuntu-common (Ubuntu): | |
importance: | Undecided → Medium |
Changed in mythbuntu-common (Ubuntu): | |
assignee: | nobody → Thomas Mashos (tgm4883) |
Changed in mythbuntu-common (Ubuntu): | |
status: | Confirmed → Fix Committed |
Changed in mythbuntu: | |
assignee: | nobody → Thomas Mashos (tgm4883) |
importance: | Undecided → Medium |
status: | New → Fix Committed |
description: | updated |
description: | updated |
Changed in mythbuntu: | |
status: | Fix Committed → Fix Released |
Changed in mythbuntu-common (Ubuntu): | |
status: | Fix Committed → Fix Released |
For the upgrade, I guess the easiest way to handle it would be to add an item to the Mythbuntu 16.04 Release Notes about disabling the tweaks.
Post upgrade, the mysql version will need to be checked and a fixed mysql tweaks file be included.