← Back to team overview

mythbuntu-bugs team mailing list archive

[Bug 1575864] Re: /etc/mysql/conf.d/mythtv-tweaks.cnf: table_cache = 128

 

*** This bug is a duplicate of bug 1576767 ***
    https://bugs.launchpad.net/bugs/1576767

I to adapted the clean 16.04 build,.. and imported a 0.27 database,...
everything went smoothly until I applied the SQL tweaks,.. and the pc
rebooted,... SQL then failed to start...

Editing the mythtv-tweaks.cnf file fixed it for me,.. comment out the
table_cache line and add table_open_cache.

You can confirm this is your error by looking in the
/var/log/mysql/error.log,....

tx guys for the simple fix

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

Title:
  /etc/mysql/conf.d/mythtv-tweaks.cnf: table_cache = 128

Status in Mythbuntu:
  New

Bug description:
  When running mysqld 5.7.12-0ubuntu1 on 16.04, the config file
  /etc/mysql/conf.d/mythtv-tweaks.cnf has a deprecated variable. As a
  result, mysqld fails to start, as seen from this error.log excerpt:

  2016-04-27T01:05:43.561013Z 0 [ERROR] unknown variable 'table_cache=128'
  2016-04-27T01:05:43.561034Z 0 [ERROR] Aborting

  Commenting this variable out or replacing it with "table_open_cache =
  128" fixes it.

To manage notifications about this bug go to:
https://bugs.launchpad.net/mythbuntu/+bug/1575864/+subscriptions


References