Breaking change in MySQL 5.7.41

Created on 30 January 2023, almost 2 years ago
Updated 25 February 2023, almost 2 years ago

Since upgrading to MySQL 5.7.41, we now receive the following error during backup and migration tasks.

Could not generate database backup from mysqldump. (error: mysqldump: Couldn't execute 'FLUSH TABLES': Access denied; you need (at least one of) the RELOAD privilege(s) for this operation (1227) )

🐛 Bug report
Status

Closed: outdated

Version

3.190

Component

DB Service

Created by

🇨🇦Canada Chris Maissan Toronto

Live updates comments and jobs are added and updated live.
Sign in to follow issues

Comments & Activities

  • Issue created by @Chris Maissan
  • 🇨🇦Canada Chris Maissan Toronto

    As a fix, we removed "--single-transaction" from the mysqldump command.

    I'm reluctant to submit a patch, as I'm not sure of the side effects of doing this. But for anyone else seeking a quick fix, this is on line 274 of db/Provision/Service/db/mysql.php

  • 🇵🇹Portugal dubois

    @chris-maissan, your instincts are correct. Turning off --single-transaction is not the way to go. See if you can pin your tools version as per https://github.com/mysql/mysql-server/commit/022e73ba6976b984658a1c26521.... Alternatively you can give users extra rights, specifically the RELOAD privilege, until this is hopefully fixed in MySQL. Aegir should probably not change anything until we have clarity on how MySQL will proceed.

  • Status changed to Closed: outdated almost 2 years ago
  • 🇦🇺Australia fenstrat Australia

    I also hit this. Pinning mysqldump (or just getting a old version of 5.7.40 binary, e.g. from /usr/bin/mysqldump) did the trick.

    Also worth noting that this has been fixed in MySQL as per https://bugs.mysql.com/bug.php?id=109685 and will be part of upcoming 5.7.42 / 8.0.33 releases. So marking as Closed (outdated) based on that.

Production build 0.71.5 2024