- 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
over 1 year ago 3:01am 25 February 2023 - 🇦🇺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.