*** This bug is a duplicate of bug 1612517 ***
https://bugs.launchpad.net/bugs/1612517
Hi,
Query cache support was removed in 8.0 (ref
https://dev.mysql.com/doc/refman/8.0/en/mysql-nutshell.html and
https://mysqlserverteam.com/mysql-8-0-retiring-support-for-the-query-
cache/).
Since these two options were in the 5.7 default config we do try to
automatically handle it on upgrades, but the default config file
location is /etc/mysql/mysql.conf.d/mysqld.cnf, so it only checks that
location (/etc/mysql/my.cnf is also used by MariaDB, so by default it
just includes the directory for the currently installed variant).
The fix for this should simply be to comment out the two lines with
query_cache, but if you receive any similar errors after doing that you
can check the mysql-nutshell page linked above to see if there's been
any change for it.
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1850895
Title:
query_cache_limit removed in mysql-8, upgrade broke
To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/mysql-8.0/+bug/1850895/+subscriptions
--
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
