MEB Backup Freezes: "Redo log writer is waiting for MEB redo log consumer which is currently reading" From MySQL Error
(Doc ID 2909451.1)
Last updated on APRIL 24, 2023
Applies to:
MySQL Server - Version 8.0 and laterMySQL Enterprise Backup - Version 8.0 to 8.0 [Release 8.0]
Information in this document applies to any platform.
Symptoms
When starting a backup, a transaction affecting many rows, especially a bulk insert.
Backup did not advance and insert of data did not advance as well.
The following message in the error log is present on MySQL error log:
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| Q(1) is the increase of innodb_redo_log_capacity the only way to solve that issue ? |
| Q(2) even if the redo space is full, why the flush is not operational ? |
| Q(3) Isn't there any way to play on any parameters which lower the time between 2 flush from redo to archive ? |