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.
