• About
  • Blog
  • Contact
  • About
  • Blog
  • Contact
MIKE WILKS

Just my thoughts on Tech

Upgrading to Ubuntu 16.04 and fixing MySQL

3/9/2016

0 Comments

 
I've been putting off upgrading one of my servers to Ubuntu 16.04 but the nagging warnings everytime I SSH in got to me. In the past I've upgraded over SSH and just ignored the health warnings about the risks of upgrading over the network. This time though I used the IPMI console. Everything went pretty well and it booted fine. This is always a heart-stopping moment because it's a remote server hosted in a datacentre with a relatively complicated disk setup with software-RAID. A number of times I've had to learn more than I ever wanted to about GRUB or MDADM to recover it.

This time it looked like it was fine. However, things are never that straight forwards. During the upgrade there was a failure to upgrade MySQL. A bit of googling and hunting around in log files revealed the answer and I'll share it here to hopefully save people some time in future. Basically if you see an error stating that you have an unknown variable called "table_cache" it is because at some point in a previous version it was renamed but they have only just declared it an error. The fix is relatively simple, just edit your my.cnf and rename it from "table_cache" to "table_open_cache". You can then reconfigure the package and it should work (dpkg --configure mysql-server-5.7). Once you do this is triggers the proper upgrade which might take a while as it will potentially need to upgrade each table.
0 Comments

    Follow @mikewilks Tweets by mikewilks

    Archives

    December 2020
    February 2018
    January 2018
    September 2017
    August 2017
    July 2017
    June 2017
    April 2017
    September 2016
    August 2016

    Categories

    All
    Broadband
    Cloud
    Co Creation
    Co-creation
    Cyber Security
    Linux
    MySQL
    Open Source
    Python
    Social Media
    Tech
    Twitter
    Ubuntu

    RSS Feed