After updating our production database to 10.4.19 (from 10.4.18) this weekend I'm seeing huge performance regressions on some queries, at some points leading to service availability issues. It looks like this might be related to the regressions mentioned in the release notes for 10.4.20, although the linked bug reports don't mention performance issues. Upstream has issued emergency releases for these issues for all the slots we currently support.
I have ebuilds ready for each slot that I can commit. In each case a straight bump from the last revision with a passing test suite. I have not tested yet if this fixes my issue since it would need to be committed somewhere first.
Probably depends on the workload, this version works fine for us. But if you have it prepared, please commit so we can test.
(In reply to Tomáš Mózes from comment #2) > Probably depends on the workload, this version works fine for us. Yes, we didn't notice issues with testing and it only shows up for some queries, but the overall effect is pretty big for us. > But if you have it prepared, please commit so we can test. I'd like to get an ok from whissi if possible, since I've never handled mariadb ebuilds before.
Could you please link sources why you believe this is an emergency release? Looks like a normal scheduled release for me. Anyway, bump is pending, currently running tests.
10.4.21 has some interesting bits: https://mariadb.com/kb/en/mariadb-10421-release-notes/. Security fixes and the only other bug is https://jira.mariadb.org/browse/MDEV-24393 which seems performance related.
.21 is an upcoming scheduled release.
The bug has been referenced in the following commit(s): https://gitweb.gentoo.org/repo/gentoo.git/commit/?id=b5e99451bce85bef37dd02003dccef3d74934537 commit b5e99451bce85bef37dd02003dccef3d74934537 Author: Thomas Deutschmann <whissi@gentoo.org> AuthorDate: 2021-08-04 01:30:10 +0000 Commit: Thomas Deutschmann <whissi@gentoo.org> CommitDate: 2021-08-04 02:00:30 +0000 dev-db/mariadb: bump to v10.4.20 Bug: https://bugs.gentoo.org/806254 Package-Manager: Portage-3.0.21, Repoman-3.0.3 Signed-off-by: Thomas Deutschmann <whissi@gentoo.org> dev-db/mariadb/Manifest | 2 + dev-db/mariadb/mariadb-10.4.20.ebuild | 1303 +++++++++++++++++++++++++++++++++ 2 files changed, 1305 insertions(+)
https://jira.mariadb.org/browse/MDEV-25714 (linked from the release notes) has that discussion (see last comment). I think the same issue applies to all other slots.
Thanks for the link! Will file a stabilization bug shortly after you confirmed that 10.4.20 works for you.
(In reply to Hans de Graaff from comment #8) > https://jira.mariadb.org/browse/MDEV-25714 (linked from the release notes) > has that discussion (see last comment). I think the same issue applies to > all other slots. Seems like I've run into https://jira.mariadb.org/browse/MDEV-25672 - just wanted to apply a simple alter `ALTER TABLE t1 DROP c1` but it failed with error `Unknown column`. The workaround mentioned in the comments (running FLUSH TABLES before the ALTER) seems to work, but version 10.4.20 fixed it. Thanks for the bump.
Not going to stabilize this version, new releases are scheduled for Thu, 05 Aug 2021.
(In reply to Thomas Deutschmann from comment #11) > Not going to stabilize this version, new releases are scheduled for Thu, 05 > Aug 2021. Released just today https://mariadb.com/kb/en/mariadb-10421-release-notes/
This is probably obsolete as we have 10.4.25 stabilized.