Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-26984

mariabackup failed due to infinite loop log scan

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 10.5.10
    • Fix Version/s: None
    • Component/s: Backup
    • 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

        Attachments

          Activity

            People

            Assignee:
            Unassigned Unassigned
            Reporter:
            leeki lee kihyun
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:

                Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.