[MDEV-26984] mariabackup failed due to infinite loop log scan Created: 2021-11-06  Updated: 2021-11-06

Status: Open
Project: MariaDB Server
Component/s: Backup
Affects Version/s: 10.5.10
Fix Version/s: None

Type: Bug Priority: Major
Reporter: lee kihyun Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: None
Environment:

CentOS 7.9



 Description   

Mariabackup is failing due to continuous log scan.

```
2021-11-06 15:14:37 0 [Note] InnoDB: Read redo log up to LSN=3929523712
[00] 2021-11-06 15:14:37 >> log scanned up to (3929523369)
[00] 2021-11-06 15:14:38 >> log scanned up to (3929523369)
[00] 2021-11-06 15:14:39 >> log scanned up to (3929523369)
[00] 2021-11-06 15:14:40 >> log scanned up to (3929523369)
[00] 2021-11-06 15:14:41 >> log scanned up to (3929523369)
[00] 2021-11-06 15:14:42 >> log scanned up to (3929523369)
[00] 2021-11-06 15:14:43 >> log scanned up to (3929523369)
[00] 2021-11-06 15:14:44 >> log scanned up to (3929523369)
[00] 2021-11-06 15:14:45 >> log scanned up to (3929523369)
[00] 2021-11-06 15:14:46 >> log scanned up to (3929523369)
[00] 2021-11-06 15:14:47 >> log scanned up to (3929523369)
[00] 2021-11-06 15:14:48 >> log scanned up to (3929523369)
[00] 2021-11-06 15:14:49 >> log scanned up to (3929523369)
[00] 2021-11-06 15:14:50 >> log scanned up to (3929523369)
[00] 2021-11-06 15:14:51 >> log scanned up to (3929523369)
2021-11-06 15:14:52 0 [Note] InnoDB: Read redo log up to LSN=3929523712
[00] 2021-11-06 15:14:52 >> log scanned up to (3929523369)
[00] 2021-11-06 15:14:53 >> log scanned up to (3929523369)
[00] 2021-11-06 15:14:54 >> log scanned up to (3929523369)
[00] 2021-11-06 15:14:55 >> log scanned up to (3929523369)
[00] 2021-11-06 15:14:56 >> log scanned up to (3929523369)
[00] 2021-11-06 15:14:57 >> log scanned up to (3929523369)
[00] 2021-11-06 15:14:58 >> log scanned up to (3929523369)
[00] 2021-11-06 15:14:59 >> log scanned up to (3929523369)
[00] 2021-11-06 15:15:00 >> log scanned up to (3929523369)
[00] 2021-11-06 15:15:01 >> log scanned up to (3929523369)
[00] 2021-11-06 15:15:02 >> log scanned up to (3929523369)
[00] 2021-11-06 15:15:03 >> log scanned up to (3929523369)
[00] 2021-11-06 15:15:04 >> log scanned up to (3929523369)
[00] 2021-11-06 15:15:05 >> log scanned up to (3929523369)
[00] 2021-11-06 15:15:06 >> log scanned up to (3929523369)
2021-11-06 15:15:07 0 [Note] InnoDB: Read redo log up to LSN=3929523712
[00] 2021-11-06 15:15:07 >> log scanned up to (3929523369)
[00] 2021-11-06 15:15:08 >> log scanned up to (3929523369)
[00] 2021-11-06 15:15:09 >> log scanned up to (3929523369)
[00] 2021-11-06 15:15:10 >> log scanned up to (3929523369)
[00] 2021-11-06 15:15:11 >> log scanned up to (3929523369)
[00] 2021-11-06 15:15:12 >> log scanned up to (3929523369)
[00] 2021-11-06 15:15:13 >> log scanned up to (3929523369)
[00] 2021-11-06 15:15:14 >> log scanned up to (3929523369)
[00] 2021-11-06 15:15:15 >> log scanned up to (3929523369)
[00] 2021-11-06 15:15:16 >> log scanned up to (3929523369)
[00] 2021-11-06 15:15:17 >> log scanned up to (3929523369)
[00] 2021-11-06 15:15:18 >> log scanned up to (3929523369)
[00] 2021-11-06 15:15:19 >> log scanned up to (3929523369)
[00] 2021-11-06 15:15:20 >> log scanned up to (3929523369)
[00] 2021-11-06 15:15:21 >> log scanned up to (3929523369)
```

I think the cause of the error is that, I did restore DB without shutdown DB. So, perhaps some log files are damaged, so the backup is not done properly. Is there any solution for this?

my situation :
mariabackup -> restore without shutdown -> mariabackup fail


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