Your message dated Fri, 16 Aug 2024 19:35:51 -0700
with message-id
<CAOU6tAD8Ab+0MhtxbaS2qk4xVmy+=2czeztsjox7kz1gwsh...@mail.gmail.com>
and subject line Re: Bug#1042399: mariadb-server 10.11.3-1 - innodb file
ibdata1 continually growing, undo logs not being purged
has caused the Debian Bug report #1042399,
regarding mariadb-server 10.11.3-1 - innodb file ibdata1 continually growing,
undo logs not being purged
to be marked as done.
This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.
(NB: If you are a system administrator and have no idea what this
message is talking about, this may indicate a serious mail system
misconfiguration somewhere. Please contact [email protected]
immediately.)
--
1042399: https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=1042399
Debian Bug Tracking System
Contact [email protected] with problems
--- Begin Message ---
Package: mariadb-server
Version 10.11.3-1
Dear maintainer,
Since upgrading from bullseye to bookworm (mariadb 10.5 -> 10.11) we are seeing
the /var/lib/mysql/ibdata1 file grow continuously, more than 1GB per day in our
case.
Undo log pages are not being purged from the ibdata1 file, even though we have
no long-running transactions still open.
Looks like this is the bug that's causing it, which is fixed in 10.11.4 -
Please could this version be released into stable as soon as possible, as it is
not possible to reduce the file size of ibdata1 without dumping all dbs,
stopping mariadb, clearing innodb files and reimporting all dbs.
https://jira.mariadb.org/browse/MDEV-31234
$ sudo innochecksum --page-type-summary ibdata1
File::ibdata1
================PAGE TYPE SUMMARY==============
#PAGE_COUNT PAGE_TYPE
===============================================
150 Index page
708497 Undo log page
8264 Inode page
0 Insert buffer free list page
4530 Freshly allocated page
46 Insert buffer bitmap
130 System page
1 Transaction system page
2 File Space Header
44 Extent descriptor page
0 BLOB page
0 Compressed BLOB page
0 Page compressed page
0 Page compressed encrypted page
0 Other type of page
===============================================
Additional information:
Undo page type: 708497
Undo page state: 0 active, 128 cached, 701887 to_purge, 0 prepared, 6482 other
index_id #pages #leaf_pages #recs_per_page #bytes_per_page
1 1 1 154 12601
2 1 0 8 200
3 4 3 82 6981
4 3 2 141 6321
5 1 1 154 5671
Floating point exception
We're using Linux 6.1.0-10-amd64 #1 SMP PREEMPT_DYNAMIC Debian 6.1.38-1
(2023-07-14) x86_64 GNU/Linux
________________________________
The Networking People (TNP) Limited. Registered office: Network House, Caton
Rd, Lancaster, LA1 3PE. Registered in England & Wales with company number:
07667393
This email and any files transmitted with it are confidential and intended
solely for the use of the individual or entity to whom they are addressed. If
you have received this email in error please notify the system manager. This
message contains confidential information and is intended only for the
individual named. If you are not the named addressee you should not
disseminate, distribute or copy this e-mail. Please notify the sender
immediately by e-mail if you have received this e-mail by mistake and delete
this e-mail from your system. If you are not the intended recipient you are
notified that disclosing, copying, distributing or taking any action in
reliance on the contents of this information is strictly prohibited.
--- End Message ---
--- Begin Message ---
Version: 1:10.11.4-1~deb12u1
Since there hasn't been any new reports, I am closing this issue are
most likely fixed in a previous upload.
--- End Message ---
