MySQL 5.7 on Xenial ships w/mysqld.cnf that causes crash
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
mysql-5.7 (Ubuntu) |
Fix Released
|
Medium
|
Lars Tangvald |
Bug Description
The mysqld.cnf file includes a commented out line for log_slow_queries = /var/log/
As it turns out, log_slow_queries was deprecated long ago and it now causes MySQL 5.7 to fail to start/restart if it exists. The current variable/option is slow_query_
For me, this is running on a clean install of Ubuntu 16.04 LTS with the default xenial package install for mysql (which is 5.7). I installed it via "apt-get install".
Changed in mysql-5.7 (Ubuntu): | |
assignee: | nobody → Lars Tangvald (lars-tangvald) |
milestone: | none → ubuntu-16.06 |
importance: | Undecided → Medium |
Changed in mysql-5.7 (Ubuntu): | |
status: | New → Triaged |
I should have been a bit more explicit in how to reproduce the problem, which is very easy. Simply un-comment the log_slow_queries like in the mysqld.cnf file and then "sudo service apache2 restart". That will return the error message, "Job for mysql.service failed because the control process exited with error code. See "systemctl status mysql.service" and "journalctl -xe" for details." For me, this is 100% reproducible using a the Xenial community image on Amazon AWS, installing nothing more than MySQL. Consequently I believe you should be able to test this locally in any environment.