mysqldump --single-transaction fails with "Couldn't execute 'FLUSH TABLES WITH READ LOCK': Access denied"
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
mysql-8.0 (Ubuntu) |
New
|
Undecided
|
Unassigned |
Bug Description
Ubuntu has included mysql-client tools from upstream 8.0.32, including mysqldump. This includes https:/
This breaks dumping with 'mysqldump --single-
=====
On AWS RDS you can't have FLUSH TABLES privilege, even as master user. This means you can't dump a large database, because without '--single-
There is another problem. We allow our devs to clone live databases. This doesn't work anymore and we are required to either:
1) Give the users in question the FLUSH TABLES privilege, if possible. This is a dangerous privilege to give because you can't give the permission only on 'WITH READ LOCK'. Or,
2) Have the live application block while the dump is running.
Our dumps are all made with '--set-
=====
Before the update, we had version 8.0.31-
I suppose the correct solution would be that upstream turns off the table flush when '--set-
In the mean time, I black-listed 8.0.32-
Ubuntu version Ubuntu 20.04.5 LTS and more I suppose.
Thanks for this bug report. Looks like this is a duplicate LP: #2003866.