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

Double entries are seen while streaming a backup with Mariabackup

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Incomplete
    • Affects Version/s: 10.2
    • Fix Version/s: N/A
    • Component/s: mariabackup
    • Labels:
      None

      Description

      While restoring backup, observed below error

      Error: Command: cat /backup/nfs/XXXX/XXX_3400_db164015_18-5_2021-06-13_0834456
      /glide/mariadb/10.2.27/bin/mbstream: Can't create/write to file './XXX_1/sys_table.frm' (Errcode: 17 "File exists")
      [00] 2021-06-14 00:28:55 /glide/mariadb/10.2.27/bin/mbstream: failed to create file.
      

      While checking mariabackup log, found that there are two entries for streaming the same file. frm and ibd files for the sys_table were streaming twice. Also, table was in the process of rename during the same time.

      [01] 2021-06-13 10:35:53 Streaming ./db_1/sys_table.ibd
      [01] 2021-06-13 10:35:53         ...done
      ..
      [01] 2021-06-13 10:40:48 Streaming ./db_1/sys_table.frm to <STDOUT>
      [01] 2021-06-13 10:40:49 Streaming ./db_1/sys_table.frm to <STDOUT>
      ..
      [00] 2021-06-13 10:40:49 DDL tracking : rename 246406 "./db_1/sys_table.ibd","./db_1/z_tmp_s1097477205h.ibd"
      [00] 2021-06-13 10:40:49 DDL tracking : rename 246406 "./db_1/sys_table.ibd","./db_1/z_tmp_s1097477205h.ibd"
      [00] 2021-06-13 10:40:49 DDL tracking : rename 246419 "./db_1/tmp_s1097477205h.ibd","./db_1/sys_table.ibd"
      [00] 2021-06-13 10:40:49 DDL tracking : rename 246419 "./db_1/tmp_s1097477205h.ibd","./db_1/sys_table.ibd"
      ..
      [00] 2021-06-13 10:40:50 Streaming db_1/sys_table.ren
      ..
      [00] 2021-06-13 10:40:50 Streaming ./db_1/sys_table.ibd
      [00] 2021-06-13 10:40:50         ...done
      

      This is not reproducible. Is this a bug? or expected behavior?

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              rob.schwyzer@mariadb.com Rob Schwyzer
              Reporter:
              niljoshi Nilnandan Joshi
              Votes:
              1 Vote for this issue
              Watchers:
              7 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Git Integration

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