[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: |
|
||||||||
| Issue Links: |
|
||||||||
| Description |
|
After i got innodb dead lock, every minutes writes to errorlog same (old) message INNODB MONITOR OUTPUT. |
| 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:
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 | |||||||||||||
| Comment by bulepage [ 2017-04-22 ] | |||||||||||||
|
set global innodb_status_output='ON'; |