** Also affects: mythbuntu Importance: Undecided Status: New ** Also affects: mythbuntu/16.04 Importance: Undecided Status: New
** Also affects: mythbuntu/16.10 Importance: Undecided Status: New ** Changed in: mythbuntu Importance: Undecided => Medium ** Changed in: mythbuntu Status: New => Fix Committed ** Changed in: mythbuntu Assignee: (unassigned) => Thomas Mashos (tgm4883) -- You received this bug notification because you are a member of UBUNTU - AL - BR, which is subscribed to Mythbuntu. https://bugs.launchpad.net/bugs/1576767 Title: Mythbuntu 16.04 LTS upgrade fails due to mythtv-tweaks.cnf for mysql Status in Mythbuntu: Fix Committed Status in Mythbuntu 16.04 series: New Status in Mythbuntu 16.10 series: New Status in mythbuntu-common package in Ubuntu: Fix Committed 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/mythbuntu/+bug/1576767/+subscriptions -- Mailing list: https://launchpad.net/~linux-traipu Post to : linux-traipu@lists.launchpad.net Unsubscribe : https://launchpad.net/~linux-traipu More help : https://help.launchpad.net/ListHelp