[MDEV-28183] Innodb-temp-data-file does not stop growing Created: 2022-03-28  Updated: 2022-10-28  Resolved: 2022-10-28

Status: Closed
Project: MariaDB Server
Component/s: Replication, Storage Engine - InnoDB
Affects Version/s: 10.6.4, 10.6.5, 10.6.7, 10.6.8, 10.6.9
Fix Version/s: 10.6.10, 10.7.6, 10.8.5

Type: Bug Priority: Major
Reporter: Alex Assignee: Thirunarayanan Balathandayuthapani
Resolution: Duplicate Votes: 0
Labels: innodb
Environment:

CentOS 7

Issue Links:
Duplicate
is duplicated by MDEV-28240 InnoDB Temporary Tablespace (ibtmp1) ... Closed
Problem/Incident
causes MDEV-26525 Replication stops because too big inn... Closed

 Description   

Since upgrading from 10.4 to 10.6 on our replication-slave, the innodb-temp-data-file "ibtmp1" keeps growing and growing, until disk is full or configured max-size is reached. (Then this causes MDEV-26525).

Workaround
systemctl restart mariadb

After restart the file "ibtmp1" starts again with 12 MB (unless configured otherwise).

 Comments   
Comment by Alex [ 2022-10-28 ]

Has been fixed with 10.6.10 in MDEV-28240.

Ticket can be closed.

Generated at Thu Feb 08 09:58:44 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.