| Summary: | =dev-db/mariadb-10.6.13 (and others) ibdata1 growth bug MDEV-31234 | ||
|---|---|---|---|
| Product: | Gentoo Linux | Reporter: | Dan Goodliffe <gentoo> |
| Component: | Current packages | Assignee: | Gentoo Linux MySQL bugs team <mysql-bugs> |
| Status: | RESOLVED FIXED | ||
| Severity: | normal | CC: | hydrapolic |
| Priority: | Normal | Keywords: | PullRequest |
| Version: | unspecified | ||
| Hardware: | All | ||
| OS: | Linux | ||
| URL: | https://jira.mariadb.org/browse/MDEV-31234 | ||
| See Also: | https://github.com/gentoo/gentoo/pull/31398 | ||
| Whiteboard: | |||
| Package list: | Runtime testing required: | --- | |
|
Description
Dan Goodliffe
2023-06-12 09:25:47 UTC
Luckily we haven't stabilized them yet (they fix CVE-2022-47015), I'll try to look into bumping to new versions. Thanks for the report Dan, maybe https://mariadb.com/kb/en/defragmenting-innodb-tablespaces/ would work too? Oh, well no. So only a dump/restore would work. "The feature described below has been deprecated in MariaDB 11.0 and was removed in MariaDB 11.1.0. See MDEV-30544 and MDEV-30545. Note that tablespace files (including ibdata1) will not shrink as the result of defragmentation, but one will get better memory utilization in the InnoDB buffer pool as there are fewer data pages in use." Yeah, I'm hoping after this they might address that long standing "you can't shrink ibdata1" limitation somehow... I know enough people have wanted to do it... but dump/restore has always been the only way. Luckily my Gentoo installs have only crept by a few MB so shrug... just hoping this bump saves some other people a headache! (In reply to Dan Goodliffe from comment #4) > Yeah, I'm hoping after this they might address that long standing "you can't > shrink ibdata1" limitation somehow... I know enough people have wanted to do > it... but dump/restore has always been the only way. > Luckily my Gentoo installs have only crept by a few MB so shrug... just > hoping this bump saves some other people a headache! The patches from previous ebuilds work, so you can test the new version from the PR. I've been running an uncommitted 10.6.14 as a simple rename of the ebuild from 10.6.13 for about 6 hrs on my dev machine, no obvious sign of trouble. The bug has been closed via the following commit(s): https://gitweb.gentoo.org/repo/gentoo.git/commit/?id=1ce09c1fe53eb0e1db16e0ba2175e332a33bed4a commit 1ce09c1fe53eb0e1db16e0ba2175e332a33bed4a Author: Tomáš Mózes <hydrapolic@gmail.com> AuthorDate: 2023-06-12 14:52:36 +0000 Commit: Sam James <sam@gentoo.org> CommitDate: 2023-06-12 15:21:20 +0000 dev-db/mariadb: add 10.4.30, 10.5.21, 10.6.14, 10.11.4 Closes: https://bugs.gentoo.org/908394 Signed-off-by: Tomáš Mózes <hydrapolic@gmail.com> Signed-off-by: Sam James <sam@gentoo.org> dev-db/mariadb/Manifest | 4 + dev-db/mariadb/mariadb-10.11.4.ebuild | 1319 ++++++++++++++++++++++++++++++++ dev-db/mariadb/mariadb-10.4.30.ebuild | 1312 ++++++++++++++++++++++++++++++++ dev-db/mariadb/mariadb-10.5.21.ebuild | 1319 ++++++++++++++++++++++++++++++++ dev-db/mariadb/mariadb-10.6.14.ebuild | 1329 +++++++++++++++++++++++++++++++++ 5 files changed, 5283 insertions(+) Additionally, it has been referenced in the following commit(s): https://gitweb.gentoo.org/repo/gentoo.git/commit/?id=29913c034d05dda5532a81663ced8904fca7a29f commit 29913c034d05dda5532a81663ced8904fca7a29f Author: Tomáš Mózes <hydrapolic@gmail.com> AuthorDate: 2023-06-12 15:15:54 +0000 Commit: Sam James <sam@gentoo.org> CommitDate: 2023-06-12 15:21:21 +0000 package.mask: mask buggy mariadb versions Bug: https://bugs.gentoo.org/908394 Signed-off-by: Tomáš Mózes <hydrapolic@gmail.com> Closes: https://github.com/gentoo/gentoo/pull/31398 Signed-off-by: Sam James <sam@gentoo.org> profiles/package.mask | 7 +++++++ 1 file changed, 7 insertions(+) Thanks Dan and Sam too. Hope all is fine now. The bug has been referenced in the following commit(s): https://gitweb.gentoo.org/repo/gentoo.git/commit/?id=3b06c46535d53af6d970ef16464521a84b3afcc7 commit 3b06c46535d53af6d970ef16464521a84b3afcc7 Author: Sam James <sam@gentoo.org> AuthorDate: 2023-06-16 21:01:46 +0000 Commit: Sam James <sam@gentoo.org> CommitDate: 2023-06-16 21:02:21 +0000 profiles: add bug ref to mariadb mask Bug: https://bugs.gentoo.org/908394 Signed-off-by: Sam James <sam@gentoo.org> profiles/package.mask | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) |
