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

mariabackup loop on Read redo log up to LSN

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.3.38
    • None
    • Backup
    • None
    • Debian 11

    Description

      Hi, I'm trying to backup my mariadb server environment (master + replica).
      I've ran this command:

      mariabackup --backup --target-dir=/backup/ --user=backup --password=backup --host=192.168.xxx.xxx

      The command loop on:

      2023-06-09 13:51:10 0 [Note] InnoDB: Read redo log up to LSN=1625600
      [00] 2023-06-09 13:51:10 >> log scanned up to (1625437)
      [00] 2023-06-09 13:51:11 >> log scanned up to (1625437)
      [00] 2023-06-09 13:51:12 >> log scanned up to (1625437)
      [00] 2023-06-09 13:51:13 >> log scanned up to (1625437)
      [00] 2023-06-09 13:51:14 >> log scanned up to (1625437)
      [00] 2023-06-09 13:51:15 >> log scanned up to (1625437)
      [00] 2023-06-09 13:51:16 >> log scanned up to (1625437)
      [00] 2023-06-09 13:51:17 >> log scanned up to (1625437)
      [00] 2023-06-09 13:51:18 >> log scanned up to (1625437)
      [00] 2023-06-09 13:51:19 >> log scanned up to (1625437)
      [00] 2023-06-09 13:51:20 >> log scanned up to (1625437)
      [00] 2023-06-09 13:51:21 >> log scanned up to (1625437)
      [00] 2023-06-09 13:51:22 >> log scanned up to (1625437)
      [00] 2023-06-09 13:51:23 >> log scanned up to (1625437)
      [00] 2023-06-09 13:51:24 >> log scanned up to (1625437)
      2023-06-09 13:51:25 0 [Note] InnoDB: Read redo log up to LSN=1625600
      [00] 2023-06-09 13:51:25 >> log scanned up to (1625437)
      [00] 2023-06-09 13:51:26 >> log scanned up to (1625437)
      [00] 2023-06-09 13:51:27 >> log scanned up to (1625437)
      [00] 2023-06-09 13:51:28 >> log scanned up to (1625437)
      [00] 2023-06-09 13:51:29 >> log scanned up to (1625437)
      [00] 2023-06-09 13:51:30 >> log scanned up to (1625437)
      [00] 2023-06-09 13:51:31 >> log scanned up to (1625437)
      [00] 2023-06-09 13:51:32 >> log scanned up to (1625437)
      [00] 2023-06-09 13:51:33 >> log scanned up to (1625437)
      [00] 2023-06-09 13:51:34 >> log scanned up to (1625437)
      [00] 2023-06-09 13:51:35 >> log scanned up to (1625437)
      [00] 2023-06-09 13:51:36 >> log scanned up to (1625437)
      [00] 2023-06-09 13:51:37 >> log scanned up to (1625437)
      [00] 2023-06-09 13:51:38 >> log scanned up to (1625437)
      [00] 2023-06-09 13:51:39 >> log scanned up to (1625437)
      

      I've tried several times, but same result... I'm trying to make a full backup pointing on my replica server.

      Server side, with "show processlist" I can see the backup connection on sleep and others connection like:

      id User Host db Command Time State Progress
      1 system user NULL Daemon NULL InnoDB purge worker NULL 0.000
      2 system user NULL Daemon NULL InnoDB purge coordinator NULL 0.000
      3 system user NULL Daemon NULL InnoDB purge worker NULL 0.000
      4 system user NULL Daemon NULL InnoDB purge worker NULL 0.000
      5 system user NULL Daemon NULL InnoDB shutdown handler NULL 0.000

      Any ideas to solve? Thanks a lot

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              stepassia Stefano Passiatore
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.