[MDEV-25319] Long BF log wait turns on InnoDB Monitor output without telling, never turns it off Created: 2021-04-01  Updated: 2021-06-29  Resolved: 2021-04-28

Status: Closed
Project: MariaDB Server
Component/s: Galera, Storage Engine - InnoDB
Affects Version/s: 10.3
Fix Version/s: 10.2.38, 10.3.29, 10.4.19, 10.5.10

Type: Bug Priority: Major
Reporter: Hartmut Holzgraefe Assignee: Jan Lindström (Inactive)
Resolution: Fixed Votes: 0
Labels: None
Environment:

Version: '10.3.21-MariaDB-log'



 Description   

We have three situations that turn on InnoDB monitor output into the error log automatically: long semaphore waits, large amount of lock heaps, and long wsrep BF waits

While the former two print something like " Starting the InnoDB Monitor to print diagnostics." into the error log first, long BF waits don't do this, they just enable the output silently.

Also while the other two occasions take care of disabling the output at a later point in time, BF long waits do not do so. The log output gets enabled, but can only be disabled again by explicit {{SET GLOBAL innodb_status_output; }} or a node restart, so flooding the log with InnoDB status output every 20 seconds.


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