[MDEV-12557] INNODB MONITOR OUTPUT write every minutes old messages to error log Created: 2017-04-22  Updated: 2018-01-08  Resolved: 2018-01-08

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - InnoDB
Affects Version/s: 10.1.22, 10.1.28, 10.1.29
Fix Version/s: N/A

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

Ubuntu 16.04 x86_64


Attachments: File my.cnf    
Issue Links:
Duplicate
is duplicated by MDEV-14776 InnoDB Monitor output generated by sp... Closed

 Description   

After i got innodb dead lock, every minutes writes to errorlog same (old) message INNODB MONITOR OUTPUT.
I uploaded to ftp.askmonty.org/private our errorlog, name MDEV-12557-mysqld.err.bz2



 Comments   
Comment by Elena Stepanova [ 2017-04-22 ]

The monitor output started appearing in the error log not because of a deadlock, but because of this:

InnoDB: Warning: difficult to find free blocks in
InnoDB: the buffer pool (338 search iterations)!
InnoDB: 0 failed attempts to flush a page! Consider
InnoDB: increasing the buffer pool size.
InnoDB: It is also possible that in your Unix version
InnoDB: fsync is very slow, or completely frozen inside
InnoDB: the OS kernel. Then upgrading to a newer version
InnoDB: of your operating system may help. Look at the
InnoDB: number of fsyncs in diagnostic info below.
InnoDB: Pending flushes (fsync) log: 0; buffer pool: 2
InnoDB: 181000753 OS file reads, 37103888 OS file writes, 3324228 OS fsyncs
InnoDB: Starting InnoDB Monitor to print further
InnoDB: diagnostics to the standard output.

The monitor output is not old, it's unique and up-to-date every time. I suppose you consider it old because of the LATEST DETECTED DEADLOCK part, which is indeed rather old and the same. It's normal, because as the name suggests, it's the latest detected deadlock. There has been no detected deadlocks since then, so the same one is printed every time.

Please let us know if you still have any questions/concerns about this.

Comment by bulepage [ 2017-04-22 ]

I don't understand why print every time ? In my opinion the bug is that every minutes ( or less) write to the error log the last detected deadlock (until the server restart, or the disk space aviable).

Comment by bulepage [ 2017-04-22 ]

I find
set GLOBAL innodb_status_output=Off; is disable the messages

Comment by bulepage [ 2017-04-22 ]

set global innodb_status_output='ON';
Make a dead lock
I make with this
https://stackoverflow.com/questions/18994621/percona-pt-deadlock-logger-doesnt-detect-deadlock/19154285#19154285
and in the error log write every minutes last dead lock

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