Ubuntu
mysql-5.7 package

MySQL 5.7.39 removes parameters, not covered in package migrations

Bug #1983091 reported by Michael Wodniok
260
This bug affects 1 person
Affects Status Importance Assigned to Milestone
mysql-5.7 (Ubuntu)
Triaged
Undecided
Unassigned

Bug Description

The parameters

* myisam_repair_threads
* parallel-recover (myisamchk command, so this does not block the start of the server itself)

are removed in between 5.7.38 and 5.7.39, this not covered by the package upgrade and blocks the start of mysql after the upgrade. Removal of the parameters resolves the problem.

See: https://dev.mysql.com/doc/relnotes/mysql/5.7/en/news-5-7-39.html#mysqld-5-7-39-feature

Revision history for this message
Lucas Kanashiro (lucaskanashiro) wrote :

Thanks for taking the time to report this bug and trying to make Ubuntu better.

The package was upgraded to version 5.7.39 in bionic to fix security issues, I do not believe we can do anything here to fix this. Please, follow the upstream documentation to remove those parameters from you configuration.

Changed in mysql-5.7 (Ubuntu):
status: New → Won't Fix
Revision history for this message
Lucas Kanashiro (lucaskanashiro) wrote :

After discussing internally with our team, this is considered a regression update and it might be fixed in the security pocket, allowing the upgrade from the old version to this one. Let's see the Security opinion about that.

tags: added: regression-update
Changed in mysql-5.7 (Ubuntu):
status: Won't Fix → Triaged
Revision history for this message
Marc Deslauriers (mdeslaur) wrote :

Where are those parameters being used?

information type: Public → Public Security
Revision history for this message
Michael Wodniok (wodniok) wrote :

Those parameters may be used in any typical configuration file of mysql. So the parameters typically may appear in `/etc/mysql/my.cnf` or `/etc/mysql/conf.d/*.cnf` (those files are configured by the package per default).

Revision history for this message
Paride Legovini (paride) wrote :

The postinst script already has a mechanism to fix deprecated options from the conf file:

https://git.launchpad.net/ubuntu/+source/mysql-5.7/tree/debian/mysql-server-5.7.postinst?h=ubuntu/bionic-devel#n112

# Default config in 5.5 and older 5.6 installations contains two deprecated
# options that were removed in 5.7. They were renamed, so we can fix this
# automatically. We create a backup of the old file

---

More upstream doc pointers on the removal of those options:

https://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar_myisam_repair_threads

https://dev.mysql.com/doc/refman/5.7/en/myisamchk-repair-options.html#option_myisamchk_parallel-recover

To post a comment you must log in.
This report contains Public Security information  
Everyone can see this security related information.
Subscribing...

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.