[MDEV-33367] FATAL ERROR: <time> Was only able to copy log from <seq_no> to <seq_no>, not <seq_no>; try increasing innodb_log_file_size Created: 2024-02-02 Updated: 2024-02-02 |
|
| Status: | Open |
| Project: | MariaDB Server |
| Component/s: | mariabackup |
| Affects Version/s: | 10.11.6 |
| Fix Version/s: | None |
| Type: | Bug | Priority: | Major |
| Reporter: | Marko | Assignee: | Unassigned |
| Resolution: | Unresolved | Votes: | 0 |
| Labels: | None | ||
| Attachments: |
|
||||||||
| Issue Links: |
|
||||||||
| Description |
|
Hello, When running backup during ongoing ALTER operation backup fails with error:
Attached full log. It is easy to reproduce issue. In my test case I used all the defaults running simple rebuild on a table.
The same error happens on a server with workload and bigger log file size. Received the same error on Percona (5.7.42) with xtrabackup, just error log was slightly different:
I am not sure if this is a bug. Thank you |
| Comments |
| Comment by Marko Mäkelä [ 2024-02-02 ] |
|
Yes, this is expected, and SET GLOBAL innodb_log_file_size to a larger value ( The error message was changed, because in I believe that this design issue would be fixed by implementing the log copying inside the server process (MDEV-14992). |
| Comment by Marko [ 2024-02-02 ] |
|
Thank you Marko for the comment and valuable information. "SET GLOBAL innodb_log_file_buffering=OFF" did not solve issue in my case but increasing innodb_log_file_size to 512MB did. I will watch implementation for MDEV-14992. |