[MDEV-26187] OOM on slave, allocating all available memory Created: 2021-07-20  Updated: 2021-07-20

Status: Open
Project: MariaDB Server
Component/s: Server
Affects Version/s: 10.6.3
Fix Version/s: None

Type: Bug Priority: Major
Reporter: Michiel Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: crash, oom
Environment:

CentOS 7.9 64 bit x64_64, 128Gb RAM


Attachments: Text File messages.log     File server.cnf    

 Description   

My replication slave starts allocating all memory once it has reached a certain binlog position. It looks like there is a very large transaction ( affecting >100.000 rows) which ran fine on the master causing this.
I simplified my config already to almost defaults, lowered the pool size and tried playing with max_binlog_cache_size and max_binlog_stmt_cache_size to no avail.

What other info can I supply in order to better diagnose this?

(NB I set MemoryLimit to 70G in limits.conf hence the messages.log showing the OOM at 73400320kB)


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