[debian-mysql] Bug#1042399: mariadb-server 10.11.3-1 - innodb file ibdata1 continually growing, undo logs not being purged

[David Heap]

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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://alioth-lists.debian.net/pipermail/pkg-mysql-maint/attachments/20230727/8be8ac2d/attachment.htm>