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

mariabackup --log-copy-interval is measured in milliseconds in 10.5 and in microseconds in 10.6

Details

    Description

      Hi, all MariaBackup developers.

      We have two MariaDB clusters, which both version 10.0.x

      And recently upgraded from 10.0.x to 10.6.2
      But I found that the log ">> log scanned up to (...)" print too fast, overwhelming the stdout/stderr. (the log file size is occupied by several gigabytes)

      But as I tested, when I upgraded from 10.0.x to 10.5.x, the log ">> log scanned up to (...)" is not so overwhelming. (the log file size is occupied by several megabytes)

      FYI, Recovered from the same database backup.

      It sounds like a bug in mariabackup, since the --log-copy-interval (default is 1000ms) can't control the log output frequency.

      # 10.5 MariaBackup
      		 
      # One log per second
      		 
      [00] 2022-02-14 17:50:25 >> log scanned up to (46200984432003)
      		 
      [00] 2022-02-14 17:50:26 >> log scanned up to (46200984454330)
      		 
      [00] 2022-02-14 17:50:27 >> log scanned up to (46200984469322)
      		 
      [00] 2022-02-14 17:50:28 >> log scanned up to (46200984491853)
      		 
      [00] 2022-02-14 17:50:29 >> log scanned up to (46200984529292)
      		 
      [00] 2022-02-14 17:50:30 >> log scanned up to (46200984561329)
      		 
       
      		 
      # 10.6 MariaBackup
      		 
      # --log-copy-interval=1000 is not working for 10.6
      		 
      [00] 2022-02-22 17:11:48 >> log scanned up to (46276221905582)
      		 
      [00] 2022-02-22 17:11:48 >> log scanned up to (46276221905582)
      		 
      [00] 2022-02-22 17:11:48 >> log scanned up to (46276221905582)
      		 
      [00] 2022-02-22 17:11:48 >> log scanned up to (46276221905582)
      		 
      [00] 2022-02-22 17:11:48 >> log scanned up to (46276221905582)
      		 
      [00] 2022-02-22 17:11:48 >> log scanned up to (46276221905582)
      		 
      [00] 2022-02-22 17:11:48 >> log scanned up to (46276221905582)
      		 
      [00] 2022-02-22 17:11:48 >> log scanned up to (46276221905582)
      		 
      [00] 2022-02-22 17:11:48 >> log scanned up to (46276221905582)
      		 
      [00] 2022-02-22 17:11:48 >> log scanned up to (46276221905582)
      		 
      [00] 2022-02-22 17:11:48 >> log scanned up to (46276221905582)
      		 
      [00] 2022-02-22 17:11:48 >> log scanned up to (46276221906153)
      		 
      [00] 2022-02-22 17:11:48 >> log scanned up to (46276221906805)
      		 
      [00] 2022-02-22 17:11:48 >> log scanned up to (46276221906805)
      		 
      [00] 2022-02-22 17:11:48 >> log scanned up to (46276221906805)
      		 
      [00] 2022-02-22 17:11:48 >> log scanned up to (46276221907586)
      		 
      [00] 2022-02-22 17:11:48 >> log scanned up to (46276221908255)

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-25765 Mariabackup reduced verbosity option for log output.

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            hcooper Harvey Cooper created issue -
            hcooper Harvey Cooper made changes -
            Field Original Value New Value
            marko Marko Mäkelä made changes -
            marko Marko Mäkelä made changes -
            Assignee Vladislav Lesin [ vlad.lesin ]
            ralf.gebhardt Ralf Gebhardt made changes -
            julien.fritsch Julien Fritsch made changes -
            Fix Version/s 10.6 [ 24028 ]
            vlad.lesin Vladislav Lesin made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            vlad.lesin Vladislav Lesin made changes -
            Summary MariaBackup 10.6 ">> log scanned up to (...)" print too fast mariabackup --log-copy-interval is measured in microseconds in 10.5 and in nanoseconds in 10.6
            vlad.lesin Vladislav Lesin made changes -
            Assignee Vladislav Lesin [ vlad.lesin ] Marko Mäkelä [ marko ]
            Status In Progress [ 3 ] In Review [ 10002 ]
            marko Marko Mäkelä made changes -
            Assignee Marko Mäkelä [ marko ] Vladislav Lesin [ vlad.lesin ]
            Status In Review [ 10002 ] Stalled [ 10000 ]
            marko Marko Mäkelä made changes -
            Summary mariabackup --log-copy-interval is measured in microseconds in 10.5 and in nanoseconds in 10.6 mariabackup --log-copy-interval is measured in milliseconds in 10.5 and in microseconds in 10.6
            vlad.lesin Vladislav Lesin made changes -
            Status Stalled [ 10000 ] In Progress [ 3 ]
            vlad.lesin Vladislav Lesin made changes -
            Fix Version/s 10.6.8 [ 27506 ]
            Fix Version/s 10.7.4 [ 27504 ]
            Fix Version/s 10.8.3 [ 27502 ]
            Fix Version/s 10.9.1 [ 27114 ]
            Fix Version/s 10.6 [ 24028 ]
            Resolution Fixed [ 1 ]
            Status In Progress [ 3 ] Closed [ 6 ]
            ralf.gebhardt Ralf Gebhardt made changes -
            mariadb-jira-automation Jira Automation (IT) made changes -
            Zendesk Related Tickets 166500

            People

              vlad.lesin Vladislav Lesin
              hcooper Harvey Cooper
              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.